Viewing 15 posts - 3,916 through 3,930 (of 8,416 total)
Tom.Thomson (4/11/2010)
You continue to distort - clearly quite deliberately.
Psychic Tom strikes again! Not only did you "know" how much documentation I had checked earlier, you now "know" that I...
April 11, 2010 at 8:40 am
Tom.Thomson (4/10/2010)
Paul White NZ (4/10/2010)
There should have been 26. Unless I missed one, or the size of the alphabet changed mid-way through...?
neither - it's just that XACT_ABORT isn't a...
April 11, 2010 at 8:09 am
Very clever question - with some well-thought-out wrong answers 🙂
First one to whinge about the explanation being 'incomplete' gets a banana :w00t: 😛
Well done.
April 11, 2010 at 4:06 am
Backup and restore both populate the percent_complete column on sys.dm_exec_requests.
April 11, 2010 at 3:34 am
Blog entry by Kimberly Tripp:
Moving Databases Around - Options
Both methods will work - but whichever you choose, be sure that you have a fully recoverable backup before you start.
April 11, 2010 at 3:31 am
Assuming that records with later shift_ids for the same employee never start earlier that earlier records (if you see what I mean)...this is a running total problem, solvable using the...
April 11, 2010 at 3:20 am
GSquared (4/9/2010)
Another option would be to copy the images you need into a parallel table, then swap the table names and drop the old table...
To minimize logging (which will be...
April 11, 2010 at 1:41 am
Garadin (4/9/2010)
You might also implement something using SET ROWCOUNT 50 or SET ROWCOUNT 100.
If forced to do it this way, I would use DELETE TOP (n), rather than SET ROWCOUNT,...
April 11, 2010 at 1:31 am
Make sure you handle the CATCH block correctly too.
BEGIN TRY
BEGIN TRANSACTION;
SELECT 1/0;
COMMIT TRANSACTION;
END TRY
BEGIN CATCH
...
April 11, 2010 at 1:11 am
One more variation on the theme:
DECLARE @Sample
TABLE (
row_id INTEGER NOT NULL
...
April 11, 2010 at 12:24 am
I would like to express my sincere thanks to the following people, for their help in producing this article:
Amanda Lawrence
Thank you everyone!
Paul
April 10, 2010 at 9:38 pm
Ninja's_RGR'us (4/10/2010)
Wow that's fast... under 3 secs on our prod server.
Now you have made my laptop feel inadequate 🙁
April 10, 2010 at 9:15 pm
Perry Whittle (4/10/2010)
personally i prefer the function, it works on SQL Server 2005 as well and does exactly what it says on the tin
Personally, I prefer to use documented and...
April 10, 2010 at 9:12 pm
Tom.Thomson (4/10/2010)
yes, that would be an improvement.
Then that is all that needed saying. You chose to make the bald statement "This explanation is wrong." - and then ramble on...
April 10, 2010 at 9:09 pm
Greg Edwards-268690 (4/10/2010)
109001 is Jan 1, 2009.
There are other such formats that make use of an assumed starting point.
Although they tend to...
April 10, 2010 at 11:09 am
Viewing 15 posts - 3,916 through 3,930 (of 8,416 total)