Viewing 15 posts - 2,926 through 2,940 (of 19,560 total)
Is somebody creating snapshots of the VMS or backing up the VMS on a nightly basis?
VM Snapshots can cause this.
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
June 2, 2014 at 12:52 pm
Sean Lange (6/2/2014)
Lynn Pettis (6/2/2014)
Between NOLOCK and no gaps in invoice numbers how much more fun can we have??No kidding. Seems to be blockhead Monday. 😀
You saying we should be...
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
June 2, 2014 at 12:47 pm
Can you be a bit more descriptive in what you need/want?
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
June 2, 2014 at 12:27 pm
science
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
June 2, 2014 at 11:05 am
You can use the OUTPUT clause for that.
Here is a link with examples
http://technet.microsoft.com/en-us/library/dd776381(v=sql.105).aspx
Go down to the "Capturing the Results of the INSERT Statement" section.
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
June 2, 2014 at 9:50 am
I say stick with what works. 2 or more monitors is pretty much a base requirement these days.
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
June 2, 2014 at 9:26 am
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
whereisSQL? (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
Sean Lange (6/2/2014)
Ed Wagner (6/2/2014)
crookj (6/2/2014)
Ed Wagner (6/2/2014)
SQLRNNR (6/1/2014)
dickoryDock
Mouse
Keyboard
Tray
System
Malfunction
Blue Screen
Death
Creeping
Lightning
Bell
Fade
Master (I guess...
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
June 2, 2014 at 9:15 am
richardd (6/2/2014)
SQLRNNR (6/2/2014)I am curious why you think this was an easy question.
The fact that it's almost identical to the question posted on 15th May helps! 🙂
http://www.sqlservercentral.com/questions/SQL+Server+2014/108889/%5B/url%5D
The date on that...
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
June 2, 2014 at 9:13 am
joe.eager (6/2/2014)
ORM'sUncommented code
+10
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
June 2, 2014 at 9:07 am
Sean Lange (6/2/2014)
Did the "Recent Posts" link get moved? I don't see it any more all of a sudden.
Looks like it got removed. That was a useful tool.
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
June 2, 2014 at 9:05 am
On the box where SSRS is running, you might want to allocate more memory for SSRS. If it is the same box as SQL Server, then you may need...
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
June 2, 2014 at 7:44 am
free_mascot (6/1/2014)
Thank you, Steve. Easy One.
I am curious why you think this was an easy 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
June 2, 2014 at 7:41 am
batgirl (6/2/2014)
From the article cited:
5.If your workload is running with database compatibility level 110 and you want to test...
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
June 2, 2014 at 7:40 am
dickory
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
June 1, 2014 at 6:30 pm
Sean Lange (5/30/2014)
crookj (5/30/2014)
Sean Lange (5/30/2014)
Revenant (5/30/2014)
Ed Wagner (5/30/2014)
crookj (5/30/2014)
Sean Lange (5/30/2014)
Ed Wagner (5/30/2014)
Sean Lange (5/30/2014)
Ed Wagner (5/30/2014)
Sean Lange (5/30/2014)
SQLRNNR (5/30/2014)
Potatofingerling
Olive Oil
Rosemary
Thyme
Parsley
Scarborough (Faire )
Simon
Silence [Sounds of]
Bridge
over
under
to grandmothers house 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
May 30, 2014 at 3:24 pm
Viewing 15 posts - 2,926 through 2,940 (of 19,560 total)