Viewing 15 posts - 7,606 through 7,620 (of 19,560 total)
restoring 2.5TB database for logshipping secondary. Paint is drying very fast!!
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
December 7, 2011 at 8:38 pm
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
December 7, 2011 at 8:36 pm
That's kind of a big topic for a forum question.
Have a look through these tutorials and see if they help.
http://msdn.microsoft.com/en-us/library/ms170246(v=sql.90).aspx
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
December 7, 2011 at 8:21 pm
Evil Kraig F (12/7/2011)
SQLRNNR (12/7/2011)
try using a cte and a row_number() ranking function.Put your query in the cte with that ranking function, then select from the cte where rownum=1
I would...
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
December 7, 2011 at 8:20 pm
Do a left join to each of those tables with the appropriate fields specified in the on clause. IN addition add 'and suchandsuchfield = 1'
e.g.
Left Outer Join BoatingWarningQaulityCodes
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
December 7, 2011 at 5:42 pm
There is not a DMV that replaces sp_who or sp_who2 in its entirety.
If you are looking for a query that is useful you could try whoisactive by Adam Machanic, or...
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
December 7, 2011 at 5:24 pm
Yes on the 64K, get them to format as 64K clusters. If filestreaming with larger files, you may want larger cluster sizes.
The spindles seems off.
The local drive is far...
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
December 7, 2011 at 4:33 pm
1. Yes, integrated is better. Many leave SQL Login enabled as a backup as well.
2. You could try creating a database user for your application without login
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
December 7, 2011 at 11:47 am
try using a cte and a row_number() ranking function.
Put your query in the cte with that ranking function, then select from the cte where rownum=1
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
December 7, 2011 at 11:40 am
Have a look at this connect item
It lists some patches and SPs that should fix the issue.
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
December 7, 2011 at 11:38 am
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
bcsims 90437 (12/7/2011)
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
mutinyHow can you do that when you're the boss???
Multiple personalities?
understatement
says who?
Legion
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
December 7, 2011 at 11:17 am
bcsims 90437 (12/7/2011)
Ninja's_RGR'us (12/7/2011)
SQLRNNR (12/7/2011)
mutinyHow can you do that when you're the boss???
Multiple personalities?
understatement
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
December 7, 2011 at 11:04 am
Where possible and feasible I like to try and consolidate - even if that means using Enterprise edition. Of course, homework has to be done before doing such a...
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
December 7, 2011 at 9:05 am
mutiny
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
December 7, 2011 at 8:52 am
L' Eomot Inversé (12/7/2011)
Steve Jones - SSC Editor (12/7/2011)
Jeff Moden (12/7/2011)
Revenant (12/6/2011)
Jeff Moden (12/6/2011)
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
December 7, 2011 at 8:51 am
Viewing 15 posts - 7,606 through 7,620 (of 19,560 total)