Hi, The SQL Server 2008 Management Studio "Connect to Database Engine" login form has a dropdown box that keeps the history of Server name & Logins...
Hi, Is it possible to use Business Intelligence Designer Studio from SQL Server 2008 to design a SSIS package that will be executed on a SQL Server...
Hi, I would like to schedule a job to execute a SSIS package. But the drop down of the New Job Step windows doesn't display the item "SQL Server...
Hi, Excerpted from SQL2K Help "If CASCADE is specified, the row is updated in the referencing table if that row is updated in the parent table. If...
Hi, A stored procedure mySlowProc performs a complicate SELECT. It creates 10 temporary tables either by SELECT ... INTO #Table1 or by doing CREATE...
Hi, Can you please help e to better understand locks which are caused by SELECT. Scenario 1: Long lasting query. Let's assume the client code call...
Hi, I'd like to connect to SQL Server 2008 CTP Nov 07 using Management Studio 2005 (SP5 + Cumulative Update 4). I got an error message "This version...
Hi, In the "Connect to a Database Engine" form which prompts for login information. Any new server name input in the "Server name" box got...
Hi, Can I install SQL Server 2005 and keep SQL Server 2000 at the same time? Or will SS2005 replace SQL2K? If SS2005 replaces SQL2K (on my laptop),...
Hi, Can you please advise a good strategy for a backup SQL2K Server? Scenario: ServerA is the production DB server. ServerB is the standby server...
One of our new DB in Dev has a size of 140 MB and can be zipped down to 3.5 MB (compression ration 98%). I am very puzzled how this DB is so...
Hi, I created a maintenance task which optimize the indexes weekly and leave 10% free space. Asa result, all indexes now have a 90% fill factor. I...
Hi, I'd like to know if a series of many UNION ALL is not detrimental to performance. Can you advise me which version below is better: Approach 1...
Hi, Can you please give me your opinion about this backup plan: 1- Differential backup every hour 2- At midnight, Truncate log and followed by Full...
Hi, I recommend the dev team to use SELECT with an explicit list of columns. The developers agree that it is more efficient (we take the only...
Hi, We have an application that must support English and French. The application currently can run with 1 byte character set. The developers choose...
Script: ======= USE Northwind GO --[1] How SQL2K know to put this comment on top of the SP? ---- CREATE PROCEDURE pTestToIgnore AS PRINT '123'...
Hi, I would like to list all the Stored Procedures ordered by their updated date. The idea is to see quickly which SP has been recently updated....
I use Enterprise Manager interactively to generate SQL scripts to create tables, views, SP, user functions and constraints. I would like to automate...
I see in BOL that does the same thing than drop + recreate an index. On the other hand, in the description for DBCC SHOWCONTIG, it says: When an...
Separate names with a comma.
