Viewing 15 posts - 4,816 through 4,830 (of 19,560 total)
zippity dodah - i got it right.
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
March 22, 2013 at 12:20 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
March 22, 2013 at 12:16 pm
This has limited testing - you can try it.
SELECT o.name AS ObjName,i.name AS IdxName,i.index_id
,c.name AS ColName,ic.column_id AS IxColumnID
FROM sys.objects o
INNER JOIN sys.columns c
ON c.object_id = o.object_id
LEFT OUTER JOIN sys.indexes i
INNER...
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
March 21, 2013 at 3:43 pm
sing4you (3/21/2013)
heart
shhh - don't tell your heart
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
March 21, 2013 at 1:27 pm
Hugo Kornelis (3/21/2013)
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
March 21, 2013 at 1:10 pm
masoudk1990 (3/19/2013)
May you help me to trace your code on paper please?
Im a newbie and im not sure how does...
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
March 19, 2013 at 11:26 pm
Jeff Moden (3/18/2013)
Evil Kraig F (3/18/2013)
Alright, let's start with the basics. You said you've read up on it...
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
March 18, 2013 at 9:51 pm
Try this, but not really sure since the expected output is not entirely certain based on the thread
/*ID | Value
---------
1 | 19
2 | 90
3 | 20
4 | 8
5 | 9
*/
DECLARE...
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
March 18, 2013 at 9:44 pm
Nice 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
March 18, 2013 at 8:13 am
Miles Neale (3/15/2013)
Say goodnight Gracie!
Goodnight Gracie
😀
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
March 15, 2013 at 5:17 pm
I am very open to the idea that I don't know what I don't know about many subjects, especially databases.
A few things come to mind real quick.
The use of cursors
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
March 15, 2013 at 5:14 pm
Lynn Pettis (3/15/2013)
Lynn Pettis (3/15/2013)
Hi, My name is Lynn and I...
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
March 15, 2013 at 4:53 pm
Lynn Pettis (3/15/2013)
SQLRNNR (3/15/2013)
Lynn Pettis (3/15/2013)
SQLRNNR (3/15/2013)
Jeff Moden (3/14/2013)
foxxo (3/14/2013)
Sign up to the petition to keep it:
https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader
I use it daily to keep track of several SQL blogs and it keeps...
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
March 15, 2013 at 10:42 am
Lynn Pettis (3/15/2013)
Stefan Krzywicki (3/15/2013)
SQLRNNR (3/15/2013)
This thread is now at 39,153 posts. Do we start the countdown now to 40,000?Isn't 39,153 to 40,000 a count up?
Naw, wait until we...
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
March 15, 2013 at 10:41 am
Stefan Krzywicki (3/15/2013)
SQLRNNR (3/15/2013)
This thread is now at 39,153 posts. Do we start the countdown now to 40,000?Isn't 39,153 to 40,000 a count up?
T - 845
And yes that 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
March 15, 2013 at 10:40 am
Viewing 15 posts - 4,816 through 4,830 (of 19,560 total)