Viewing 15 posts - 451 through 465 (of 2,436 total)
... not backwater ... mainstream on the web if you know where to look ...
http://www.ss64.com/nt/index.html
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 24, 2008 at 10:36 am
What ?!?!?
No Regeneration ?
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 24, 2008 at 10:33 am
Without knowing more about your issue this is all that I can offer:
http://www.connectionstrings.com/
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 24, 2008 at 8:12 am
I have learned and practiced many of the 'time savers' listed in this excellent discussion thread. What I have found out over time is that all of these suggestions,...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 23, 2008 at 8:39 am
You may also want to check and see that the old tempdb .mdf and .ldf files are cleaned up (deleted) as well.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 20, 2008 at 9:30 am
I just knew that I should have had that second cup of coffee before posting ... oh well ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 20, 2008 at 8:55 am
I so wanted to see 'execution by SQL' this morning ...
but alas ... no one suggested ## tables instead of # tables ...
so much for the morning entertainment !
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 20, 2008 at 8:43 am
I would add to the list the following:
The ability to say to someone with all sincerity and earnest:
"I do not know at present the cause/resolution of this issue we are...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 20, 2008 at 7:47 am
Collations and character sets ...
They are so necessary and can cause so much ado ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 19, 2008 at 3:10 pm
There is one extremely important reason to go to SP4 for SQL 2000. This is because MS Support for SP3 expired in July of 2007 whereas SP4 is supported until...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 19, 2008 at 9:38 am
... hmmm ...
Granting this type of authority on a development environment seems quite reasonable. Granting this authority on a production system temporarily during the execution of a database conversion...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 19, 2008 at 9:21 am
garyreeds (6/18/2008)
next -d we need to add traceflags by separating with;?and the sqlservice should be stooped before adding trace flags?
Correct me if Iam wrong.
No separators are needed.
e.g -T1204 -T3605
As for...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 19, 2008 at 8:37 am
EM = SQL Server Enterprise Manager ...
you will also see QA in many posts as well.
QA = SQL Server Query Analyzer.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 19, 2008 at 8:13 am
To answer you question on where columns are added is a bit lengthy. To really oversimplify simplify things greatly a row on a page in SQL Sever is broken...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 18, 2008 at 3:49 pm
Check out this post:
http://www.sqlservercentral.com/Forums/Topic400504-146-1.aspx
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
June 17, 2008 at 4:02 pm
Viewing 15 posts - 451 through 465 (of 2,436 total)