Viewing 15 posts - 8,536 through 8,550 (of 9,248 total)
John
cant find the link at present, it detailed the NTFS cluster size and disk alignment within the windows OS. MS indicated that changing default cluster sizes,etc didnt necessarily boost performance.
I've...
January 8, 2009 at 1:47 pm
Wow, some great responses here. Did I open a can of worms? I appreciate all the feedback both negative and positive. This was only ever meant to be a "quick...
January 8, 2009 at 12:15 pm
option 2 should include the client
January 8, 2009 at 5:45 am
ALZDBA (1/7/2009)
January 8, 2009 at 5:41 am
ALZDBA (1/7/2009)
Truncation usually occurs after each checkpoint but can be delayed under some conditions
this is the key here, it should and generally does but there can be instances when it...
January 7, 2009 at 11:50 am
BOL sql2005 Dec2008 is the version
as i understood it, recovery interval option will make regular log truncations by issuing checkpoint, but in severe cases where transactions over run the checkpoint...
January 7, 2009 at 11:33 am
Perry Whittle (1/6/2009)
can you post details of the job steps?
January 7, 2009 at 2:52 am
danchard (6/30/2008)
I wanted to enter server name/instance name
the correct syntax to use is
servername\instance
January 7, 2009 at 2:52 am
check your index widths too, depending on the columns included indexes can be quite large
January 7, 2009 at 2:49 am
also instead of re creating and syncing the logins use the following link
http://support.microsoft.com/kb/246133
to move logins between servers, preserving the database to user relationship
January 6, 2009 at 4:48 pm
Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛
ha ha, i was wondering if this post would catch your eye Jeff.
foxjazz (1/6/2009)
January 6, 2009 at 4:28 pm
rons (1/6/2009)
but would like to see the differences between the 2 tables in one result window.
then use the correlated query Ninja supplied above
January 6, 2009 at 2:17 pm
foxjazz (1/6/2009)
And you can still use c# it's easier to do this in a valid programming language than t-sql because it's easier to debug.
OK, now is time to leave the...
January 6, 2009 at 2:02 pm
foxjazz (1/6/2009)
it's probably easier to use a cursor to iterate through your first table.
well deserving of a pork chop this one 😀
a simple select with a correlated sub query will...
January 6, 2009 at 1:49 pm
Ells (1/5/2009)
1.The data warehouse has simple recovery mode so I dont believe this will have an issue as the database is backed up weekly before a load is performed.
under simple...
January 6, 2009 at 1:15 pm
Viewing 15 posts - 8,536 through 8,550 (of 9,248 total)