Viewing 15 posts - 91 through 105 (of 147 total)
As for the reason why it runs quicker the second time through it's because the execution plan has been cached.
March 6, 2008 at 8:00 am
Jumping on the bandwagon here: only the second statement returned the correct value for my birthdate. Gimme my point! ARGH!
😛
March 6, 2008 at 6:37 am
Oh how I wish I worked in a perfect world! If so, I'd have my logs on a dedicated RAID 1, my tempdb on another and my data on...
February 29, 2008 at 10:05 am
I suggest removing rights to any databases that this login may have first prior to deleting the login. As suggested this can all be done in SSMS. Right-click...
February 29, 2008 at 9:48 am
Like Lowry, in our environment (both SQL 2000 and 2005) I am responsible as the DBA to make sure all databases are being backed up correctly and am responsible for...
February 29, 2008 at 9:43 am
What do you consider "abnormal"? What is your tempdb spec'd at currently? Are we discussing SQL 2000 or 2005? Optimizing tempdb in 2005 is quite different than...
February 29, 2008 at 9:23 am
No matter what you specify for the location of program files and for data files, SQL will still place files in C:\Program Files\Microsoft SQL Server\80 (or 90 if this is...
February 28, 2008 at 8:47 pm
Detach/Attach v. Backup/Restore is really a matter of personal preference. So long as you copy/paste the data/log files in the Detach/Attach instead cut/paste you can recover by re-attaching the...
February 28, 2008 at 8:38 pm
I completely forgot about that! The other contributing authors are no slouches either.
February 23, 2008 at 7:23 am
Henry, I believe your FTP commands would be in the .txt file referenced here in the script:
[font="System"]-- FTP for the file list
SELECT @sql = 'FTP -n -v...
February 22, 2008 at 9:05 am
Definitely agree Brandie, just wanted to explain for any lurkers out there so that they just don't go around giving out dbo under the belief that they need to in...
February 22, 2008 at 9:00 am
Brandie, I took this as the individual has SSMS and should be able to "see" only a specific database(s) in the Databases node of the Object Explorer and not "see"...
February 21, 2008 at 1:52 pm
Once you revoke the View Any Database, if you then execute sp_changedbowner for database X for a given login that login should see that database, as well as master and...
February 20, 2008 at 7:44 pm
I really would not disable the default trace if I were you. Think of it as SQL's "black box". The load it places on the server should be...
February 20, 2008 at 7:28 pm
The documentation should tell you what the initial size will be; very small initially. The size of the database really depends upon how many servers you plan on monitoring,...
February 20, 2008 at 7:19 pm
Viewing 15 posts - 91 through 105 (of 147 total)