Viewing 15 posts - 10,981 through 10,995 (of 19,560 total)
I would agree that the distinct is most likely the cause of less than accurate results.
If any rows of your dataset match, you will only get the one row.
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
February 18, 2011 at 2:10 pm
Personally, I prefer more real-estate on screen. Multiple monitors helps with that too.
Essential is plenty of memory and fast disks.
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
February 18, 2011 at 11:12 am
Kit G (2/18/2011)
CirquedeSQLeil (2/18/2011)
Ray K (2/18/2011)
Peter Trast (2/18/2011)
Brandie Tarvin (2/18/2011)
WOTD: JeansDjinn
genes
Mean Gene ...
Mr. Green Jeans!
I was sure somebody would go the okerlund route on that one.
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
February 18, 2011 at 11:10 am
Gianluca Sartori (2/18/2011)
GilaMonster (2/18/2011)
Craig Farrell (2/18/2011)
Stefan proved to me he's a much better abuser of fools than I am. May I request recruiting his assistance? 🙂
No! Leave Lennie alone....
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
February 18, 2011 at 9:27 am
Nice one Lynn. Glad to see the re-publish on 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
February 18, 2011 at 9:22 am
Ray K (2/18/2011)
Peter Trast (2/18/2011)
Brandie Tarvin (2/18/2011)
WOTD: JeansDjinn
genes
Mean Gene ...
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
February 18, 2011 at 9:21 am
SKYBVI (2/18/2011)
paul.knibbs (2/18/2011)
Doesn't sound like a very long time to me. What's the speed of the link this backup file is being copied over?
Do you think that once it gets...
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
February 18, 2011 at 9:18 am
Thanks for the 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
February 17, 2011 at 8:50 pm
No discrepancy with the LSNs. The log chain would not be broken
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
February 17, 2011 at 2:53 pm
Is there something that runs overnight preventing you from having logshipping run through the night every night?
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
February 17, 2011 at 1:59 pm
The constraints with logshipping is the network and the latency that will be imposed in copying a file of that size. 25Gb will copy faster but it is still...
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
February 17, 2011 at 1:38 pm
Please provide the info that Lutz has requested. It would be extremely helpful.
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
February 17, 2011 at 1:27 pm
GSquared (2/17/2011)
Craig Farrell (2/17/2011)
GSquared (2/17/2011)
Ken Jennings? I was more thinking along the lines of expertsexchange.com.Until you just mentioned it I don't think I ever quite caught that one... 😛
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
February 17, 2011 at 1:14 pm
What is the insert statement that you are trying to use?
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
February 17, 2011 at 10:42 am
Stefan Krzywicki (2/17/2011)
Jack Corbett (2/17/2011)
george sibbald (2/17/2011)
Koen Verbeeck (2/16/2011)
Jeff Moden (2/16/2011)
CirquedeSQLeil (2/16/2011)
--get spid of code requestor
sp_whorequestedcodeIntheThread 'Wayne'
--use returned spids to verify the request
dbcc inputbuffer(61)
--output
'Wayne...
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
February 17, 2011 at 10:32 am
Viewing 15 posts - 10,981 through 10,995 (of 19,560 total)