Viewing 15 posts - 19,441 through 19,455 (of 19,560 total)
USE master
--revoke VIEW ANY DATABASE from public
grant VIEW ANY DATABASE to [public]
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 3:09 pm
How about a poll for which picture is better?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 1:03 pm
I wasn't quite thinking that old - but it works:cool:
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 12:52 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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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,...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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....
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
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.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 10:34 am
A third option is to use a third party tool like RedGates SQL Compare and Data Compare.
However, if this is going to be a repeatable procedure, I would take the...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 10:07 am
Ryan D. (8/27/2009)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 27, 2009 at 9:57 am
Being able to answer this question without more information is like taking a shot in the dark.
Some of the things you might look for are to see if other users...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 26, 2009 at 6:54 pm
I want to emphasize what Lynn said about the cursor - WHY are you using a cursor to move data from table to table?
Besides the article that Lynn suggested, please...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
August 26, 2009 at 6:48 pm
Viewing 15 posts - 19,441 through 19,455 (of 19,560 total)