Viewing 15 posts - 3,601 through 3,615 (of 19,560 total)
OCTom (2/19/2014)
Luis Cazares (2/18/2014)
Sean Lange (2/18/2014)
OCTom (2/18/2014)
Answer:...
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
February 19, 2014 at 8:07 am
Grant Fritchey (2/19/2014)
SQLRNNR (2/19/2014)
Grant Fritchey (2/19/2014)
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant 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
February 19, 2014 at 8:04 am
Grant Fritchey (2/19/2014)
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not...
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
February 19, 2014 at 7:58 am
GilaMonster (2/19/2014)
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not sure...
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
February 19, 2014 at 7:55 am
cygne17_2 77208 (2/19/2014)
Hi all,Thanks for all your answer.
Very helpful !
regards
Cygne
You're welcome
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
February 19, 2014 at 7:54 am
rodjkidd (2/19/2014)
SQLRNNR (2/19/2014)
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
Jason, not sure about...
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
February 19, 2014 at 7:53 am
GilaMonster (2/19/2014)
It's not necessarily the easy questions that we moan about. It's the ones with no thought or no research or the ones that are unreadable...
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
February 19, 2014 at 7:53 am
rodjkidd (2/19/2014)
Koen just say you are a Holistic SQL Server Consultant - you'll be fine then 😀
Rodders...
Just wondering if a holistic consultant does spinal adjustments??:cool:
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
February 19, 2014 at 7:37 am
ALICIA SABAT (2/19/2014)
A database transaction log continues to grow after you upgrade to
SQL Server 2008...
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
February 19, 2014 at 7:35 am
rebuild
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
February 19, 2014 at 7:33 am
You're welcome.
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
February 19, 2014 at 7:30 am
Igor Micev (2/19/2014)
SQLRNNR (2/19/2014)
Nice question. I wonder how many people have used identity in this way (select into...).
It's used in migrations. For example if you have to migrate users...
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
February 19, 2014 at 7:28 am
Glad to hear that you have it fixed and working now.
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
February 19, 2014 at 7:28 am
Nice question. I wonder how many people have used identity in this way (select into...).
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
February 19, 2014 at 12:31 am
You could use a table variable or you could take advantage of row_number()
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
February 18, 2014 at 8:42 pm
Viewing 15 posts - 3,601 through 3,615 (of 19,560 total)