Viewing 15 posts - 11,176 through 11,190 (of 22,219 total)
There is no "ideal" deployment. In most systems I've worked on, I put the database into source control and then use comparisons between source control and a database to generate...
"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
April 3, 2012 at 5:46 am
Depending on what you're trying to do, you may want to use a different account for production and non-production environments in order to prevent any chance of a non-production environment...
"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
April 3, 2012 at 5:42 am
You just use the OBJECT_NAME function to identify the object in question.
"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
April 3, 2012 at 5:39 am
That's a good one. It looks like the minus sign is reversing the division, creating a multiplication when is then divided, unless you set the parenthesis so that it's a...
"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
April 3, 2012 at 5:28 am
What about setting up an extended events session and just capturing changes over time. Then, if something goes wrong, you query the extended events results and see who did what...
"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
April 3, 2012 at 5:16 am
Just to validate, you do have log backups in place? If you're not backing up the log frequently enough, you may be seeing excessive growth. Make sure you are 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
April 3, 2012 at 5:13 am
The thing to do is to put your database into source control, just like a piece of code. That way you can always track changes. Even if only you use...
"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
April 3, 2012 at 5:09 am
Personally, I'd take no advice from anyone online about licensing. Get in touch with your Microsoft rep to do these validations. No one here is responsible if we get it...
"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
April 3, 2012 at 5:02 am
If you look at the input buffers you'll see a stored procedure call and something with an object id: Object Id = 1053962831
I'd start there. What does that Object id...
"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
April 3, 2012 at 5:01 am
I wouldn't use a linked server within SSIS. It should be able to connect directly to both servers in question. Is that the cause of the problem? Not sure since...
"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
April 3, 2012 at 4:40 am
If it's LiteSpeed, you have to use LiteSpeed to restore it. You can use the utility to uncompress it and then restore it.
Also, if it wasn't LiteSpeed, you can try...
"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
April 2, 2012 at 5:27 pm
By the way, all these examples are for local variables, not parameters. There is a distinct difference. Unless the statement is recompiled, the values within variables will not be "sniffed"...
"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
April 2, 2012 at 3:28 pm
SQLKnowItAll (4/2/2012)
Lynn Pettis (4/2/2012)
Grant Fritchey (4/2/2012)
Lynn Pettis (4/2/2012)
MyDoggieJessie (4/2/2012)
Lian (4/2/2012)
Hi,we are running SQL Server 2005 Enterprise Edition 64 bit
I'd like to hear your suggestion anyway Lynn!
In SQL Server 2008 and...
"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
April 2, 2012 at 1:54 pm
Lynn Pettis (4/2/2012)
MyDoggieJessie (4/2/2012)
Lian (4/2/2012)
Hi,we are running SQL Server 2005 Enterprise Edition 64 bit
I'd like to hear your suggestion anyway Lynn!
In SQL Server 2008 and newer when running Enterprise Edition,...
"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
April 2, 2012 at 12:03 pm
To check when the last time statistics were updated, use the STATS_DATE function.
The rules for when auto update fires are a bit more complicated. They're listed here.
If you add...
"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
April 2, 2012 at 9:09 am
Viewing 15 posts - 11,176 through 11,190 (of 22,219 total)