Viewing 15 posts - 2,416 through 2,430 (of 19,560 total)
batgirl (8/1/2014)
SQLRNNR (8/1/2014)
Ed Wagner (8/1/2014)
Fettuccinebroccoli
bocci
balloon
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 1, 2014 at 11:05 am
Ed Wagner (8/1/2014)
Fettuccine
broccoli
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 1, 2014 at 9:54 am
Keith Tate (8/1/2014)
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
and post the entire output. Once corruption has been ruled out then we can start...
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 1, 2014 at 9:46 am
Running 2012 on a desktop os that is probably running a bunch of other things at the same time?
Probably have AV enabled on the desktop too?
Disks are configured differently?
Faster disk...
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 1, 2014 at 9:34 am
You can use @@ROWCOUNT and if the @@ROWCOUNT is greater then 0 then pass a 1 to the output parameter otherwise pass a 0 to the output parameter.
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
July 31, 2014 at 10:17 pm
cdm33.com (7/31/2014)
Great forum by the way.Thanks a lot,
Chris
Glad you like it. Stick around and you will learn quite a bit.
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
July 31, 2014 at 10:04 pm
GilaMonster (7/31/2014)
Michael Valentine Jones (7/31/2014)
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
July 31, 2014 at 4:26 pm
If you used the query provided by Lowell, it does not create a temp table. He used a cte.
But a temp table would be efficient in handling this type...
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
July 31, 2014 at 2:56 pm
Steve Jones - SSC Editor (7/31/2014)
SQLRNNR (7/31/2014)
Because you just had two pina coladas?
That's completely misworded. It's "because you had just two pina coladas."
LOL
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
July 31, 2014 at 2:45 pm
You are 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
July 31, 2014 at 2:38 pm
Nice answer Eirikur
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
July 31, 2014 at 2:35 pm
Markus (7/31/2014)
SQLRNNR (7/31/2014)
How much freespace are you dealing with? How much freespace on the volume that houses tempdb?187 Gig of free space on the drive.
That message can be thrown...
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
July 31, 2014 at 2:25 pm
Christian.stringer3 (7/31/2014)
SQLRUNNR its from a database, what do you mean by doing select, where would I do that?
You used the INSERT ... VALUES method in your example.
If you look at...
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
July 31, 2014 at 2:23 pm
The Dixie Flatline (7/31/2014)
Ed Wagner (7/31/2014)
SQLRNNR (7/31/2014)
swasheck (7/31/2014)
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
July 31, 2014 at 2:18 pm
cdm33.com (7/31/2014)
Jason,Thanks for your help - i think i got it. it's a bit nerve racking testing on production.
Let's just up-vote that say 1 million times.:-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
July 31, 2014 at 2:16 pm
Viewing 15 posts - 2,416 through 2,430 (of 19,560 total)