Viewing 15 posts - 6,091 through 6,105 (of 22,219 total)
Luis Cazares (5/15/2015)
Leading commas or...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 9:50 am
Eric M Russell (5/15/2015)
Grant Fritchey (5/15/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 9:27 am
Alvin Ramard (5/15/2015)
Grant Fritchey (5/15/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 7:19 am
What Gail says ( pretty much what I always say).
The way I usually put it, build your structures and write your queries with the fact that there is an optimization...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:45 am
Biggest thing to remember is that you're going to have to maintain a two-phase commit on your transactions. You have to successfully write to both SQL Server and Couchbase in...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:42 am
mdsantos (5/15/2015)
But after some minutes I get "...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:39 am
Just this, all by itself, is going to lead to poor performance:
ltrim(ppt_ClaimsManagerDescriptionManual)
If you can't bring in a consultant, and I'm with Kevin, you need to, second best choice, get...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:38 am
Alan.B (5/13/2015)
RECOMPILE and Copying the parameter as a local variable will likely eliminate that possibility of parameter sniffing.
Careful, those are two very different possible solutions to a bad parameter...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:36 am
Question: Can you outline for me how to best design a system so that I can move it between Oracle, SQL Server, MySQL, DB2, Couchbase, DocumentDB, Hadoop, Redshift, Azure SQL...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:32 am
Jeff Moden (5/14/2015)
Eric M Russell (5/14/2015)
Define "working correctly".Easy... it doesn't automatically call me at 3 in the morning even if it broke. 😛
Guys, you're getting this one all wrong. The...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:28 am
I'd strongly recommend getting the execution plan and understanding how SQL Server is interpreting your T-SQL. That will drive you towards making positive choices in optimizing the code.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:22 am
GilaMonster (5/14/2015)
dwain.c (5/14/2015)
I gotta wonder what the ANSI standards say about this one!Perfectly legal afaik.
It's legal. I've seen this before. List all the tables and then all the ON clauses...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:19 am
If you're using the syntax BACKUP DATABASES, unless you specify a list of databases to include or exclude (and you have to use the EXCLUDE key word), then it's backing...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:16 am
Build a database that categorizes your books, movie collection, My Little Pony collection, whatever. Take the time to normalize, think about the possible reports you could run 'All science fiction...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:12 am
If you connect to the server using SQL Server Management Studio, you'll see which database is offline or in suspect mode. Otherwise, you can query sys.databases to see the current...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 15, 2015 at 6:08 am
Viewing 15 posts - 6,091 through 6,105 (of 22,219 total)