Viewing 15 posts - 3,346 through 3,360 (of 19,560 total)
dwain.c (3/18/2014)
Oh God Steve, don't get me started!Good editorial!
Oh please - get started Dwain 😉
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, 2014 at 7:15 am
We also need those little wins that come from having our endeavors solve problems, even if we'd build software better the next time. The important thing is that you try...
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, 2014 at 7:14 am
Yeah, it will just continue to be slow. Not much way of improving the speed except to reduce the number of pages.
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, 2014 at 7:07 am
EricEyster (3/17/2014)
Eric M Russell (3/17/2014)
JAZZ Master (3/17/2014)
Ed Wagner (3/17/2014)
Eric M Russell (3/17/2014)
JAZZ Master (3/17/2014)
Daniel Bowlin (3/17/2014)
Revenant (3/17/2014)
Eric M Russell (3/17/2014)
Ed Wagner (3/17/2014)
Eric M Russell (3/17/2014)
inaugurationStart
dissonance
discord
record
breaker
Peacemaker
Cheesemaker (or any maker of dairy...
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, 2014 at 6:09 am
Do you have read committed snapshot enabled?
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 17, 2014 at 10:48 am
Steve Jones - SSC Editor (3/17/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
March 17, 2014 at 9:00 am
Try this article that can help with that
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
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 17, 2014 at 8:45 am
Well done.
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 17, 2014 at 6:04 am
Wagon
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 17, 2014 at 5:58 am
andrew gothard (3/16/2014)
GilaMonster (3/16/2014)
I have two clients where I'm writing up a performance report which includes an entire section on their use of NoLock. Going to be an interesting week
PHB...
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 17, 2014 at 5:57 am
EricEyster (3/16/2014)
DSP-120308 (3/15/2014)
TomThomson (3/14/2014)
JAZZ Master (3/14/2014)
Ed Wagner (3/14/2014)
Kurt W. Zimmerman (3/14/2014)
EricEyster (3/14/2014)
Revenant (3/14/2014)
Ed Wagner (3/14/2014)
BWFC (3/14/2014)
PaperDocumentation
Absent
vanished
evaporate
Milk
Chocolate
Fireguard
Hot Chocolate
Marshmallow
peppermint
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 16, 2014 at 9:00 am
Admingod (3/14/2014)
Configuring SQL to put TEMPDB completely on RAM? .If RAM is dedicate to TempDB will improve performance?Thanks
You can get similar effects by putting tempdb on a Fusion-IO card.
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 16, 2014 at 8:59 am
GilaMonster (3/16/2014)
rraza (3/15/2014)
I think we will restore the file backup of that time when table was deleted.
Why a file restore? What's your justification for choosing that type of restore operation?...
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 16, 2014 at 8:56 am
GilaMonster (3/15/2014)
If you check index fragmentation, enable locked pages and enable (but don't configure) resource governor, SQL will magically start to use less memory
http://www.sqlservercentral.com/Forums/FindPost1551457.aspx
and...
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 16, 2014 at 8:21 am
Greg Edwards-268690 (3/13/2014)
The Dixie Flatline (3/13/2014)
andrew gothard (3/13/2014)
The Dixie Flatline (3/12/2014)
SQLRNNR (3/12/2014)
The Dixie Flatline (3/12/2014)
Thanks in advance.
P.S. Please don't...
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 13, 2014 at 8:32 am
Viewing 15 posts - 3,346 through 3,360 (of 19,560 total)