Viewing 15 posts - 4,366 through 4,380 (of 19,560 total)
Steve Jones - SSC Editor (7/31/2013)
SQLRNNR (7/31/2013)
Steve Jones - SSC Editor (7/31/2013)
...
So I get this is probably in jest and partially true, but it's insulting. ...
That being said, the icons...
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, 2013 at 11:44 am
PhilipC (7/31/2013)
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, 2013 at 11:23 am
Steve Jones - SSC Editor (7/31/2013)
...
So I get this is probably in jest and partially true, but it's insulting. ...
That being said, the icons shouldn't have been rolled out without...
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, 2013 at 11:21 am
Lynn Pettis (7/31/2013)
FYI, Anyone considering Care Packages to Afghanistan, the first package from home took 9 days to get here.
you petitioning for twinkies or ding dongs?
Where do we send the...
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, 2013 at 11:08 am
the previous doc mentioned should help you get the databases moved.
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, 2013 at 11:03 am
Revenant (7/31/2013)
crookj (7/31/2013)
JAZZ Master (7/31/2013)
The Dixie Flatline (7/31/2013)
Insensitivecrass
Tactless
hillbilly
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
July 31, 2013 at 11:01 am
You can try the query in this article
http://www.sqlservercentral.com/articles/sp_who2/70222/
You can also try sp_whoisactive (link in the discussion on that article.
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, 2013 at 2:23 am
Is your query running a loop, cursor or does it have multiple batches within 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
July 31, 2013 at 2:12 am
one method is to use dbcc inputbuffer
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, 2013 at 2:07 am
The usual way would be to monitor specific queries and evaluate the execution plans of those queries. You run the query, tune the indexes as appropriate (keeping in mind...
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, 2013 at 1:04 am
You could teach them how to do it via SQLCMD or PoSH.
As far as a GUI tool, I don't recommend anything other than SSMS for User Administration.
If you have 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
July 31, 2013 at 1:01 am
ChrisM@Work (7/31/2013)
laurie-789651 (7/30/2013)
ChrisM@Work (7/30/2013)
JAZZ Master (7/30/2013)
Revenant (7/30/2013)
L' Eomot Inversé (7/29/2013)
crookj (7/29/2013)
sing4you (7/29/2013)
L' Eomot Inversé (7/29/2013)
The Dixie Flatline (7/29/2013)
JAZZ Master (7/29/2013)
Daniel Bowlin (7/29/2013)
achepain
gain
loss
profit
Seer
Sear
Sears
Craftsman
Crofter
Bonxie
Spoot
Spook
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, 2013 at 12:58 am
I think the first step is to instill a sense of ownership / pride in the developer in the product they develop. If you own it, are you happy...
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, 2013 at 12:57 am
The tool to use would be SSMS
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, 2013 at 12:51 am
Here is an alternative article you can follow if you would like a different way of doing it with SSIS
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/87652/
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, 2013 at 12:36 am
Viewing 15 posts - 4,366 through 4,380 (of 19,560 total)