Viewing 15 posts - 7,726 through 7,740 (of 19,560 total)
Toreador (11/30/2011)
KWymore (11/30/2011)
I am curious how many out there are utilizing sql_variant and under which circumstances?
I've used it for generic audit tables, where we store something like table name, column...
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
November 30, 2011 at 9:00 am
Hugo Kornelis (11/30/2011)
Gerardo Galvan Castro (11/30/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
November 30, 2011 at 8:59 am
Thanks for the question.
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
November 30, 2011 at 8:53 am
Daniel Bowlin (11/30/2011)
Thirty-first anniversary
Congrats
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
November 30, 2011 at 8:47 am
Microsoft already has all of that information for you to see through the system catalogs. Check the views that Craig mentioned.
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
November 29, 2011 at 2:43 pm
If you are looking for a simple combine of the two (and if perf is not an issue - though I would look into changing this to a set-based routine...
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
November 29, 2011 at 2:10 pm
I can't see a good reason for one to be affected and not the other.
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
November 29, 2011 at 10:07 am
I am of the same opinion as Gus. Simplify this query. I am not seeing a reason from the code provided to have it be dynamic. If...
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
November 29, 2011 at 10:05 am
L' Eomot Inversé (11/29/2011)
SQLRNNR (11/29/2011)
ChrisM@Work (11/29/2011)
Evil Kraig F (11/22/2011)
SQLRNNR (11/22/2011)
riddleQuestion Mark
Mark is innocent!
3rd degree
Guantanamo
The Rock
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
November 29, 2011 at 10:02 am
Here are a few that I like to use
http://jasonbrimhall.info/2011/11/17/table-space-revised-again/
http://jasonbrimhall.info/2011/11/21/table-space-cs-part-deux/
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
November 29, 2011 at 9:57 am
ChrisM@Work (11/29/2011)
Evil Kraig F (11/22/2011)
SQLRNNR (11/22/2011)
riddleQuestion Mark
Mark is innocent!
3rd degree
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
November 29, 2011 at 9:45 am
Even with the 3rd party tool, it would be more likely to be able to recover if you are in Full recovery. Check that setting first.
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
November 28, 2011 at 11:38 pm
Do you have tran log backups?
Is the server in Full or Simple recovery model?
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
November 28, 2011 at 11:32 pm
Thanks for the question.
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
November 28, 2011 at 11:22 pm
You can only use one datasource at a time.
If both sources are required at the same for the chart, consider porting the data from one into the other and then...
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
November 28, 2011 at 11:18 pm
Viewing 15 posts - 7,726 through 7,740 (of 19,560 total)