Viewing 15 posts - 6,376 through 6,390 (of 19,560 total)
Do you have the folder visible under any of your Programs folders for SQL 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
April 18, 2012 at 12:35 pm
ACinKC (4/18/2012)
hbtkp (4/13/2012)
hbtkp (4/13/2012)
he just told me i cant help u with code,so i need help from you,
hbtkp...
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
April 18, 2012 at 12:32 pm
This is definitely Oracle.
In SQL Server you would want to use a CASE statement.
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
April 18, 2012 at 12:29 pm
I have several reports that rely on procs that use temp tables or table variables. We would need more info on this question to be able to answer 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
April 18, 2012 at 12:26 pm
Brandie Tarvin (4/18/2012)
I have a "Incorrect syntax near ncp". How do I resolve?
And now I shall hide in the Tent. Guard...
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
April 18, 2012 at 11:45 am
PiMané (4/18/2012)
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
April 18, 2012 at 11:20 am
Lynn Pettis (4/18/2012)
Here is a our first challenge. No one should post again until we get what has been requested.
that kind of blatant hijacking needs to earn him 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
April 18, 2012 at 11:12 am
sqlfriends (4/18/2012)
Thanks all, I am not an English native speaker, sometimes it is hard to find a word that is vividly describe what I want.This helps a lot.
NP. ...
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
April 18, 2012 at 11:09 am
broken
flawed
buggy
incompatible
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
April 18, 2012 at 11:03 am
Yes this query could be maxing out tempdb. A lot depends on the size of the varchar field. I have seen queries (similar to what you have described)...
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
April 18, 2012 at 11:01 am
Lynn Pettis (4/18/2012)
SQLRNNR (4/18/2012)
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
My wife is a special education teacher with a lot of training and experience in behavior modification. She...
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
April 18, 2012 at 10:55 am
wheaties
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
April 18, 2012 at 10:53 am
Lynn Pettis (4/18/2012)
The Dixie Flatline (4/18/2012)
My wife is a special education teacher with a lot of training and experience in behavior modification. She has taught me...
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
April 18, 2012 at 10:49 am
We need more of these types, Koen.
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
April 17, 2012 at 9:52 pm
Nice question
Thanks
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
April 17, 2012 at 9:44 pm
Viewing 15 posts - 6,376 through 6,390 (of 19,560 total)