Viewing 15 posts - 13,591 through 13,605 (of 19,560 total)
Lynn Pettis (6/11/2010)
Some people really need to RTFM, or in this case, BOL.
Yup - or at least finish reading that book from which the example was taken.
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 11, 2010 at 8:13 am
davidshephard (6/11/2010)
Yes from Larson's book..
Do you mind sharing which book it 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
June 11, 2010 at 8:10 am
I don't see this as a trick question. I see it as a good question. There is something to be learned from this question and thus it 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
June 10, 2010 at 11:25 pm
malleswarareddy_m (6/10/2010)
CirquedeSQLeil (6/9/2010)
malleswarareddy_m (6/9/2010)
then create new db with wizard....
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 10, 2010 at 11:11 pm
Steve Jones - Editor (6/10/2010)
Jeff Moden (6/10/2010)
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 10, 2010 at 11:10 pm
You're 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
June 10, 2010 at 11:09 pm
You're 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
June 10, 2010 at 8:25 pm
I would start by reading the following article from PostGres.
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 10, 2010 at 4:27 pm
Just building on what Zendada did a bit.
/*
drop table sample
CREATE TABLE [Sample](
[ID] [int] NOT NULL,
[account] char(2),
[DataMonth] [varchar](10) NOT NULL,
[InvQuantity] decimal(12,5) NULL,
CONSTRAINT [PK_Sample] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF)...
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 10, 2010 at 4:02 pm
This might be a good resource. There is a lot that can be done with wmi.
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 10, 2010 at 3:33 pm
UMG Developer (6/10/2010)
CirquedeSQLeil (6/10/2010)
nelsonj-902869 (6/10/2010)
michael.kaufmann (6/10/2010)
Very interesting behavior--especially given the fact that BOL states one cannot set the MODEL database to READ_ONLY (that's...
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 10, 2010 at 3:30 pm
Oleg Netchaev (6/10/2010)
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 10, 2010 at 3:30 pm
DiskIO is number of reads and writes.
CPUTIme is duration of the spid. Sometimes a spid will be sleeping (or orphaned) and this counter will continue to grow.
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 10, 2010 at 3:27 pm
great series and surprising goal. Not a blackhawks fan, but they deserved 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
June 10, 2010 at 3:10 pm
Steve Jones - Editor (6/10/2010)
Someone should tell the NBA refs that. A bit too many calls in the first three games.
There have been too many calls. I have less...
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 10, 2010 at 3:05 pm
Viewing 15 posts - 13,591 through 13,605 (of 19,560 total)