Viewing 15 posts - 19,441 through 19,455 (of 19,564 total)
Again that would depend. Read Gails blog that she posted earlier on this topic.
August 27, 2009 at 10:12 pm
Good point on the behavior pattern adjustment.
August 27, 2009 at 4:11 pm
Lynn Pettis (8/27/2009)
GSquared (8/27/2009)
Lynn Pettis (8/27/2009)
Asking this:
i need the query(dbname,size,recoverymodel) for all databases in a server.
tells me you haven't even tried to find an answer...
August 27, 2009 at 3:35 pm
A possible reason for the redgate question stems from the users existing in a database. It seems that the users it sees might be orphaned and so it is...
August 27, 2009 at 3:19 pm
USE master
--revoke VIEW ANY DATABASE from public
grant VIEW ANY DATABASE to [public]
August 27, 2009 at 3:13 pm
Has somebody by chance tweaked with the public role in an effort to secure the databases and server?
August 27, 2009 at 3:09 pm
How about a poll for which picture is better?
August 27, 2009 at 1:03 pm
Think of it as this way:
The MCTS you mentioned is the first Step to the MCITP. The same exam for MCTS is required for MCITP. If you are...
August 27, 2009 at 12:51 pm
Ever thought of upgrading to a previous version. Sorry guys - not a fan of Office 2007, ribbons and frilly things - yuck.:-D
August 27, 2009 at 12:41 pm
On the status column, how unique / selective is the data in the column?
How many rows could you see returned with a status of 0?
Do you have an index on...
August 27, 2009 at 12:36 pm
GilaMonster (8/27/2009)
Lynn Pettis (8/27/2009)
Now to this one. This individual really needs to figure out how to open and read BOL.
Agreed. I'm getting a little tired of his very basic,...
August 27, 2009 at 12:09 pm
Lynn Pettis (8/27/2009)
GilaMonster (8/27/2009)
Lynn Pettis (8/27/2009)
GilaMonster (8/27/2009)
I love these kinds of questions. http://www.sqlservercentral.com/Forums/Topic778499-146-1.aspxMaybe I'll elaborate later on what it depends on...
Personally, looks like a good reseearch topic for some one....
August 27, 2009 at 12:01 pm
Michael Tocik (8/27/2009)
HiI came across this which we currently use.
http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx
Something extra you may want to look at
Nice find.
A note about this dashboard is that it requires SQL 2k5 sp2....
August 27, 2009 at 11:40 am
Also, this msdn article explicitly states model,master and tempdb as being prohibited - thus leaving the door open for msdb snapshots.
August 27, 2009 at 10:34 am
Viewing 15 posts - 19,441 through 19,455 (of 19,564 total)