Forum Replies Created
Viewing 15 posts - 9,961 through 9,975 (of 22,224 total)
-
RE: Best Approach to Archieve DB
If you can make changes to your architecture, you might want to look into partitioning the data. That makes it very easy to move data out of one database...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Read Committed_Snapshot
Best suggestion I can make is to measure the number and size of your current transactions. Get a sense of the amount of data that is actively being modified and...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: SQL Server 2008 R2 - Failed to connect to SQL Server
Are you getting a specific error? Are you connecting to a default instance or a named instance? Try both. Also try just supplying the IP address instead of the server...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Google Reader is shutting down!
Jeff Moden (3/14/2013)
foxxo (3/14/2013)
http://googlereader.blogspot.com.au/2013/03/powering-down-google-reader.htmlSign up to the petition to keep it:
https://www.change.org/petitions/google-inc-please-do-not-shut-down-google-reader
I use it daily to keep track of several SQL blogs and it keeps RSS feeds synchronised between my phone,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Read Committed_Snapshot
It does put considerable additional load on the tempdb, so be sure you're ready to handle that. The amount depends on the level of data changes you're dealing with. Other...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: table partitioning
ratheesh4sql (3/13/2013)
planning to do the partitioning for the main table with region wise.....So that we can split the data into a different file group and the data accessible also will..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
Stefan Krzywicki (3/15/2013)
Hey Grant,Good panel last night. Should be more of those.
Thanks! That was a lot of fun. And I didn't make Adam angry more than once or twice, so...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events
Jonathan Kehayias (3/15/2013)
Grant Fritchey (3/13/2013)
SQLKnowItAll (3/13/2013)
When is the book coming out Grant? I am going to be one of the first buyers...Ha! Don't hold your breath. I still haven't...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Are the posted questions getting worse?
SQLRNNR (3/15/2013)
Steve Jones - SSC Editor (3/15/2013)
hahaha
Should we show him how to work the site?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Insert Performance
Sergiy (3/13/2013)
Grant Fritchey (3/13/2013)
But a few years ago, I did do a series of tests, not from ODBC, but through ADO.NET, and we saw serious performance degradation when using single..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Very frustrating performance tuning!
shannonjk (3/13/2013)
That is odd that the merge should be faster than the hash, since if I add hash to the join (i.e LEFT HASH JOIN) it executes in half the..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events
SQLKnowItAll (3/13/2013)
When is the book coming out Grant? I am going to be one of the first buyers...Ha! Don't hold your breath. I still haven't received the first chapter.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events
SQLRNNR (3/13/2013)
It might be typical for your environment. But that doesn't mean it has to be acceptable.That many parallelism deadlocks can mean that you have a lot of poor...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Extended Events
SQLRNNR (3/13/2013)
You are dealing with a Debbie Downer.XE is far more than what Grant said and obviously far more than Debbie said. XE can get you information about spinlocks,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning -
RE: Insert Performance
Sergiy (3/13/2013)
Year, hard to argue.Except, probably, for this one:
Grant Fritchey (3/13/2013)
But, if you have to do individual inserts (and I'd be curious why), then small sets of transactions, say 10,000..."The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore RooseveltAuthor of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 9,961 through 9,975 (of 22,224 total)