Viewing 15 posts - 46 through 60 (of 100 total)
I am very interested in how the rebuilding of a clustered index would result in data being moved to another partition. The partition of a particular record in a table...
December 9, 2009 at 9:39 am
Not all rendering formats support drill-down. I believe that only HTML and PDF support it. I know that Excel does NOT.
June 15, 2009 at 10:28 am
Never Mind. I think Jack has it.
February 27, 2009 at 8:18 am
Matty,
Try and declare the variables at the package level instead of inside the script, and then reference tham inside the script from the DTSVariables collection. I THINK that you are...
February 27, 2009 at 8:16 am
Longy (2/27/2009)
Rich (2/27/2009)
Based on the queries supplied, you should get 1 and 1, because the first statement includes the wildcard at the beginning, so the # SHOULD be returned.
The answer...
February 27, 2009 at 6:52 am
Based on the queries supplied, you should get 1 and 1, because the first statement includes the wildcard at the beginning, so the # SHOULD be returned.
February 27, 2009 at 6:17 am
Charlie,
The 2779 (Implementing) will go over many of the new services available within SQL2005 as compared to SQL2000, and will also talk about the programming objects. The 2780 (Administering) will...
March 27, 2008 at 5:04 am
Just in case anyone is interested, the reason that When Null did not work is because SQL tried to use an equality operator to compare the values. Null is the...
November 21, 2007 at 9:43 am
Have you heard of Service Broker? Basically, it allows you to send messages to a stored procedure that will then be executed as the message is received. Your application can...
November 20, 2007 at 1:47 pm
The answer lies within the execution plan. Suggest that you go into SSMS, write the three versions of the query, and then compare their execution plans to determine the answer....
November 12, 2007 at 9:16 am
The users could be leaving their PC's logged in but locked for more than 12 hours, therefor the Kerberos ticket is expiring, and SQL Server will no longer recognize the...
November 7, 2007 at 2:56 pm
Technically, the osql command IS successful, because sp_start_job will return a success code if it is able to start the requested job. It does not wait for that job to...
November 5, 2007 at 2:42 pm
The easiest thing to do would be to take the ir.ratingkey out of the query. Then, you would get a sum for all ratingkeys for an inspno. The only other...
November 5, 2007 at 2:37 pm
Does user1 have access to this share from your local PC or is it only available from the server? User1 needs to be able to see the share from wherever...
November 5, 2007 at 8:47 am
Viewing 15 posts - 46 through 60 (of 100 total)