Viewing 15 posts - 8,536 through 8,550 (of 19,560 total)
Patti Johnson (9/24/2011)
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
September 24, 2011 at 2:38 pm
If you are filling up a 2TB t-log, I'd split the reorg up into a targeted approach. Try doing a handful of tables per night and rotate through 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
September 24, 2011 at 10:14 am
Robert.Sterbal (8/15/2011)
What are your usage permissions on this script? Can I republish it internally?Thanks!
-Robert
This script is actually verbatim the same script that Microsoft Created for use by Activity Monitor.
You can...
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
September 23, 2011 at 11:28 pm
You could also take a look at this article
http://www.sqlservercentral.com/redirect/articles/75880/
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
September 23, 2011 at 11:23 pm
Some areas that I know I have knowledge gaps in are SSAS, PowerShell and CLR. I am working to learn more about those.
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
September 23, 2011 at 10:37 pm
Dup question - post answers here.
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
September 23, 2011 at 10:28 pm
On 2008 IIS is not required.
What happens if you try to connect to this url?
http://Stuart-VAIO:80//reportManager/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
September 23, 2011 at 3:07 pm
adonetok (9/23/2011)
Yes, there is a primary key on ID column.I want to keep min(ID)
I think the best thing you could do is provide DDL for the tables involved. Otherwise,...
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
September 23, 2011 at 12:49 pm
I dare say that in this case you are probably missing part of the reason for apparent dupes. Do you have an OrderDetail table? Or does the Order...
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
September 23, 2011 at 12:34 pm
Ninja's_RGR'us (9/23/2011)
GilaMonster (9/22/2011)
SQL Server MVP Deep Dives 2 will soon be available for pre-order and early access via Manning publishers: http://www.manning.com/delaney/
Chapter 8: "The how and why of Page Restores",...
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
September 23, 2011 at 11:41 am
GilaMonster (9/23/2011)
SQLRNNR (9/23/2011)
GilaMonster (9/23/2011)
I could plug Jonathan Kehayias's upcoming book that I know covers it (in chapter 4). but it won't be out for a couple weeks...
Title? That is...
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
September 23, 2011 at 11:21 am
GilaMonster (9/23/2011)
I could plug Jonathan Kehayias's upcoming book that I know covers it (in chapter 4). but it won't be out for a couple weeks...
Title? That is a book...
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
September 23, 2011 at 10:58 am
Ninja's_RGR'us (9/23/2011)
SQLRNNR (9/23/2011)
Ninja's_RGR'us (9/23/2011)
SQLRNNR (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Good thing NFL players don't work...
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
September 23, 2011 at 10:56 am
Ninja's_RGR'us (9/23/2011)
SQLRNNR (9/23/2011)
Steve Jones - SSC Editor (9/23/2011)
Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv
Good thing NFL players don't work for Amazon....
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
September 23, 2011 at 10:51 am
Based on your descriptions, it looks like you have SQL 2008 installed and are trying to install SQL 2008 R2 SP1.
Make sure you install SQL 2008 SP1 and not 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
September 23, 2011 at 10:49 am
Viewing 15 posts - 8,536 through 8,550 (of 19,560 total)