Viewing 15 posts - 8,956 through 8,970 (of 19,560 total)
Roy Ernest (8/19/2011)
Thank You everyone for the input on TVP. It looks like something worth investing my time to do some performance testing.
indubitably :-D:-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 19, 2011 at 9:57 am
ALZDBA (8/19/2011)
WayneS (8/18/2011)
Steve Jones - SSC Editor (8/18/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
August 19, 2011 at 9:55 am
Jeff Moden (8/18/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
August 19, 2011 at 9:54 am
Nice
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 19, 2011 at 9:53 am
I'd expect the Dell raid controller to be better but the HP chipset and processor to be better or at least as good.
I am scratching my head on this one.
You...
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 19, 2011 at 9:52 am
Guras (8/19/2011)
I ran the DBCC openTran(mydb)but there is no open transactions.
How do I to locate queries that consume a large amount of log space?
Thanks for your help.
Beyond doing 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
August 19, 2011 at 9:50 am
Along with that shrink, make sure you account for VLFs. Check the article in my sig list by Kimberly Tripp
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 19, 2011 at 9:46 am
innumerable
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 19, 2011 at 9:37 am
Yes, database first and then the masterkey.
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 18, 2011 at 10:15 pm
Jeff Moden (8/18/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
August 18, 2011 at 10:15 pm
Jeff Moden (8/18/2011)
Roy Ernest (8/18/2011)
I would love everyones opinion on this topic please.
I've never used them. I've always used something else because they didn't use to be available. ...
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 18, 2011 at 6:44 pm
For future reference, here is another query to help get to that head blocker
SELECT
[Session ID] = s.session_id,
[User Process] = CONVERT(CHAR(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
August 18, 2011 at 6:39 pm
Change d:\blobstore to something like d:\blobstore2
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 18, 2011 at 6:32 pm
Revenant (8/18/2011)
crookj (8/18/2011)
Ray K (8/18/2011)
crookj (8/18/2011)
Ray K (8/18/2011)
bopeavy (8/18/2011)
Daniel Bowlin (8/18/2011)
Ray K (8/17/2011)
--------------------------------------------------------------------------------
bopeavy (8/17/2011)
--------------------------------------------------------------------------------
OUT!
SAFE!!!
Let's go to the instant replay
DVR!!
VCR!!!
(I'm old fashioned -- what...
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 18, 2011 at 5:30 pm
There are many reasons a master key may be required (TDE, create encrypted data in a column, filestream). In all of these cases, you should backup the master key....
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 18, 2011 at 5:29 pm
Viewing 15 posts - 8,956 through 8,970 (of 19,560 total)