[Articles] Upgrading to 2012 |
| Posted: 18 Apr 2013 11:00 PM PDT Are many people upgrading to SQL Server 2012? Is it worth the cost for your company for any existing instances? Steve Jones asks the question this week. |
| You are subscribed to email updates from SQLServerCentral.com Articles tagged Editorial To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
[MS SQL Server] working with sql server 2008 R2 |
| working with sql server 2008 R2 Posted: 19 Apr 2013 12:09 AM PDT I want to know the exact difference between sql 2008 and sql 2008 R2.Which is preferable and when to use R2 version.I already have Sql 2008 installed enterprise edition how install R2 edition? |
| Migrating DTS Packages from SQL 2000 to 2008 Posted: 27 May 2010 07:14 AM PDT Hi All,I am looking to migrate the SQL 2000 applications to SQL Server 2008and the OS will be Windows 2003 Server.the server where we run a lot of DTS's. I understand that SQL 2008requires some add-ons to be downloaded and installed to make DTS'swork.Can you please let me know which type of add-ons I need to download it? and where can I get that?Thanks in advance,Vamsi. |
| Posted: 26 Sep 2011 06:51 PM PDT Hi Folks,I have a sql server 2000 instance.i migrated my databases and DTS packages to SQL server 2008 R2.Am unable to open the DTS packages which i migrated from SQL SERVER 2000 to SQL SERVER 2008 R2.i've installed SQL server 2000 DTS Designer components and SQL server 2005 Backward compatability Softwares which was suggested by Microsoft and then copied the .dll and .rll files suggested by microsoft and then changed the path in Environment Variables.After doing all these things as well am getting the same error while opening DTS pkg. in SQL SERVER 2008 R2error is :SQL Server 2000 DTS Designer Components are required to edit DTS packages. Install the special web download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SqlServer.DtsObjectExploreUI).Please Help me...TIA... |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
[SQL 2012] Switching data warehousing to SSIS from Cognos |
| Switching data warehousing to SSIS from Cognos Posted: 19 Apr 2013 02:08 AM PDT Has anyone switched to using SSIS for their ETL? Currently using Cognos Data Manager but possible we're going to switch to SSIS so interested in experiences, tips, pitfalls, etc...Thanks. |
| SSD + HDD Server, where I install os, sql binaries, mdf, ldf and tempDB? Posted: 18 Apr 2013 11:36 PM PDT Hello,My company has a new Server:64 GB RAM2 x Intel 320 SSD 120GB RAID12 x SATA3 1TB RAID 1We will use this Server only for SQL Server 2012, for an small 10GB database, with high workload.I would like to know wich is the best ditribution of OS, SQL Server 2012 binaries, MDF, LDF as TEMPDB in this Hardware.Thanks. |
| Enabling Always On availablity :Couldn't enable the option Posted: 18 Apr 2013 09:59 PM PDT Hi,, In sql server 2012 creating a cluster , i had added servers and the next step is Access point for administering the cluster which i need to give the IP address dedicated to the cluster.I don't have a dedicated IP address to assigning to creating cluster. i couldn't pass this step for creating clustering. Kindly help in passing this through. |
| Posted: 18 Apr 2013 08:24 PM PDT can we give a copy of a database to someone and it be packaged in such a way so that they cannot see the table structure / design????????Thanks in advance,suresh. |
| Linked Server to SQL 2000 from SQL 2012 Posted: 18 Jun 2012 07:29 AM PDT Hi Guys,I am able to create linked server to SQL 2008 from SQL 2012 and it works fine; however, I am not able to do so with SQL 2000.TITLE: Microsoft SQL Server Management Studio------------------------------The test connection to the linked server failed.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Cannot create an instance of OLE DB provider "SQLNCLI10" for linked server "TESTSERVER". (Microsoft SQL Server, Error: 7302)------------------------------BUTTONS:OK------------------------------ |
| SSMS error opening maintenance plans Posted: 18 Apr 2013 03:49 AM PDT I've applied everything I can find for sql 2012 management tools and mine now show 11.0.3350.0 both on my desktop and on my test server. Getting two types of errors.If I remote onto the sql server, managing maintenance plans works fine. From my desktop I get the Object reference not set to an instance of an object with "vsintegration" mentioned. Must be something about visual studio or other software on my workstation. When opening the sql error log viewer and selecting a Windows NT log like application, I get "the given key was not present in the dictionary"I'm going to uninstall Visual Studio and everything related to sql server 2005, 2008 and 2012 and re-install the 2012 management tools because others here will soon run into these errors. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
[T-SQL] Filter duplicate students via T-SQL |
| Filter duplicate students via T-SQL Posted: 18 Apr 2013 11:56 PM PDT I need to filter for duplicate students:For same student, if one instance of IDNo is null then check if both instances of Tel3 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel3 are not identical for same Student, check if both instances of Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel2 are not identical for same Student, check if an instance of Tel3 & Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.View example below:-------------------Student IDNo Tel3 Tel2 SortKyle 91686 721377200 721377200Kyle NULL 721377200 721377200 Bronwyn 94123 775498898 777642110Bronwyn NULL 777642110 777642110 Mark NULL 772170700 772476573Mark NULL 772476573 772476573 |
| filter duplicate students via T-SQL Posted: 18 Apr 2013 11:52 PM PDT I need to filter for duplicate students:For same student, if one instance of IDNo is null then check if both instances of Tel3 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel3 are not identical for same Student, check if both instances of Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel2 are not identical for same Student, check if an instance of Tel3 & Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.View example below:-------------------Student IDNo Tel3 Tel2 SortKyle 91686 721377200 721377200Kyle NULL 721377200 721377200 Bronwyn 94123 775498898 777642110Bronwyn NULL 777642110 777642110 Mark NULL 772170700 772476573Mark NULL 772476573 772476573 |
| Filter duplicate students via T-SQL Posted: 18 Apr 2013 11:53 PM PDT I need to filter for duplicate students:For same student, if one instance of IDNo is null then check if both instances of Tel3 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel3 are not identical for same Student, check if both instances of Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel2 are not identical for same Student, check if an instance of Tel3 & Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.View example below:-------------------Student IDNo Tel3 Tel2 SortKyle 91686 721377200 721377200Kyle NULL 721377200 721377200 Bronwyn 94123 775498898 777642110Bronwyn NULL 777642110 777642110 Mark NULL 772170700 772476573Mark NULL 772476573 772476573 |
| filter duplicate students via T-SQL Posted: 18 Apr 2013 11:52 PM PDT I need to filter for duplicate students:For same student, if one instance of IDNo is null then check if both instances of Tel3 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel3 are not identical for same Student, check if both instances of Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.if both instances of Tel2 are not identical for same Student, check if an instance of Tel3 & Tel2 are identical for same Student, if they are - use it to populate field Sort with the value.View example below:-------------------Student IDNo Tel3 Tel2 SortKyle 91686 721377200 721377200Kyle NULL 721377200 721377200 Bronwyn 94123 775498898 777642110Bronwyn NULL 777642110 777642110 Mark NULL 772170700 772476573Mark NULL 772476573 772476573 |
| How to stop SSMS from adding database name to scripts Posted: 18 Apr 2013 07:31 AM PDT Is there an option to prevent SSMS from adding the Database Name to scripts it generates?For example, if I do a right click on a table in the Object Explorer then select "Script Table as"INSERT To", it will create the insert statement with the database on it. That has caused me headaches when I create it and use it in my stored procedure and don't notice it. I would never want to do that.I have the same issue with Stored Procedures. When you do a modify, it always puts a "USE Database" at the top. I need to get rid of that one to for the same reason.Thanks,Tom |
| How to get zero values for a row Posted: 18 Apr 2013 08:31 PM PDT I have done some and tried to use the ISNULL command but this is not working.My query is this:[code="sql"]select count (*) as 'Total', datename (mm, date_time) as 'Month Name',MONTH (date_time) as 'Month' ,Year (date_time) as 'Year'from opencallleft join updatedbon updatedb.callref = opencall.callrefwhere (updatetxt like 'Call assigned to the WIBS group%')and year(date_time) in ('2013')and priority not in ('UNIX')and probcode like ('CL%')group by datename (mm, date_time), Year (date_time), MONTH (date_time)order by Year, MONTH [/code]I did try using the ISNULL command as I said, but this did not return zero rows.It's been a while since I wrote reports, I think my mind has gone blank. Any help is appreciated! |
| how to convert the below subquery to joins Posted: 18 Apr 2013 07:41 PM PDT how to convert the below subquery into join ..SELECT CtryId, WrkflwId, Dt FROM stepHistory H WHERE EXISTS (SELECT * FROM (SELECT WrkflwId, CtryId , max(DtTm) DtTm FROM stepHistory GROUP BY WrkflwId, ctryId ) S WHERE S.WrkflwId = H.WrkflwId AND S.DtTm = H.DtTm AND H.CtryId = S.CtryId) AND SteTyId = 2 ----I have use the above query as inner join because i have to run the above query into an datawarehous applicance which wont support subqueryplease help---------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Posted: 18 Apr 2013 11:51 AM PDT Hi,Let's say I have the following table with just 1 record:SELECT Field1, Field2, Field3 FROM tblreturns 11, 22, 33What would be a query to return something like: <CustomInformation> <ColumnValue name="Field1">11</ColumnValue> <ColumnValue name="Field2">22</ColumnValue> <ColumnValue name="Field3">33</ColumnValue> </CustomInformation>?Thanks! |
| Please Help ...Sorry if posted it twice/ in wrong forum topic Posted: 18 Apr 2013 08:57 AM PDT Have a Table with the CSV Values in the columns as belowID Name text 1 SID,DOB 123,12/01/1990 2 City,State,Zip NewYork,NewYork,01234 3 SID,DOB 456,12/21/1990 What i need is to get is 2 tables in this scenario as out put with the corresponding values , These table should be generated Dynamically as the values in the source table varies every week.ID SID DOB 1 123 12/01/1990 3 456 12/21/1990ID City State Zip2 NewYork NewYork 01234Is there any way of achieving it using a Cursor/Procedure or any other method in SQL server? |
| passing parm from view to multistatement table valued function Posted: 18 Apr 2013 08:54 AM PDT Does anyone know of a sneaky/devious way to pass a parameter (value) from a view to the input parameter of a multi-statement table valued function? I am trying to substitute a function for a table referenced in the view to return a single row.I am limited to using a view by third party software and can't do any pre-processing. I simply have a pop up window that accepts an input parameter of search argument(s) that matches existing column value(s) for a column that exists in the view. Most replies to this question are "you can't get there from here". Anybody have another route I can follow. Maybe a way to convince the view to be a little less static? |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
Hi Everybody,
Where can I find some good educational material on tuning ETL procedures for a data warehouse environment? Everything I've found on the web regarding query tuning seems to be geared only toward OLTP systems. (For example, most of our ETL queries don't use a WHERE statement, so the vast majority of searches are table scans and index scans, whereas most index tuning sites are striving for index seeks.)
I have read Microsoft's "Best Practices for Data Warehousing with SQL Server 2008R2," but I was only able to glean a few helpful hints that don't also apply to OLTP systems:
But I still feel like I'm missing some very crucial concepts for performant ETL development.
BTW, our office uses SSIS, but only as a glorified stored procedure execution manager, so I'm not looking for SSIS ETL best practices. Except for a few packages that pull from source systems, the majority of our SSIS packages consist of numerous "Execute SQL" tasks.
Thanks, and any best practices you could include here would be greatly appreciated.
-Eric
social.technet.microsoft.com/Forums
Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.
sqlteam.com
Weekly SQL Server newsletter with articles, forum posts, and blog posts via email. Subscribers receive our white paper with performance tips for developers.
sqlteam.com
