Viewing 15 posts - 16,141 through 16,155 (of 22,226 total)
Generally a security policy would be defined as who has access to what information and how do you insure that this is being enforced. So you need to pieces of...
"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
December 3, 2009 at 7:49 am
Sounds like named pipes isn't set up. I wouldn't use it personally. TCPIP should be about everything you need.
"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
December 3, 2009 at 7:47 am
Kwisatz78 (12/3/2009)
Is your system OLTP or data warehouse?
How many cores do you have?
My system is OLTP and uses 4 cores. Currently MAXDOP is set to 0 with threshold...
"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
December 3, 2009 at 7:14 am
Depending on the volatility of the system, you could take a look at the output from the default trace. It should be available on the server with the log &...
"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
December 3, 2009 at 7:12 am
GilaMonster (12/3/2009)
One of the non-clustered index is having all the columns in that table.
Why? Is that index...
"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
December 3, 2009 at 7:11 am
Um, restarting the server would definately stop the trace unless you put it into a boot script that fires when SQL Server starts up.
Plus, that trace, that's the black box...
"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
December 3, 2009 at 7:04 am
I'm probably extremely confused, but wouldn't this do what you're looking for?
SELECT c.categoryID
,SUM(c.categoryID)
FROM @Customers c
...
"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
December 3, 2009 at 6:53 am
Gail's already focused on the core of the question, you're only going to see two plans in the cache for a given query (assuming the same parameters, yada-yada).
But, you can...
"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
December 3, 2009 at 6:48 am
laurav (12/3/2009)
"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
December 3, 2009 at 6:24 am
What, no video?
Excellent editorial. The link seems to be missing to the T-Mobile story in the UK. Any chance of posting it?
We're working with a tough piece of software. 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
December 3, 2009 at 5:52 am
thefourthdoctor (12/2/2009)
- build the second box
- backup dbs on the first
- restore on the second
-...
"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
December 3, 2009 at 5:45 am
After you move the database you need to be sure that you set the compatibility level to 10. You should also update all the statistics on the database.
The safest way...
"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
December 2, 2009 at 6:45 am
Speaking from a pure paranoia standpoint, I'd want to be able to have both servers online at the same time. That way you can leave your existing system in place...
"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
December 2, 2009 at 6:42 am
Whatever context SQL Server is running under, it does not have access to that network share. Even if you do, and you're running the command, it doesn't matter, the 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
December 2, 2009 at 6:14 am
When you insert a row, it has to be placed in the correct place in an index. When you do a batch insert of umpty-x number of rows, they also...
"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
November 30, 2009 at 8:44 am
Viewing 15 posts - 16,141 through 16,155 (of 22,226 total)