Viewing 15 posts - 13,441 through 13,455 (of 22,219 total)
Another problem is cross-database dependencies. If you have lookup tables in different databases, you can't use declarative referential integrity, foreign keys, to ensure the consistency of the data. You'd have...
"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
January 31, 2011 at 6:13 am
My general approach is a little different than others. I tend to cluster on the most frequently accessed path into the data that is also selective enough to index well....
"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
January 31, 2011 at 6:11 am
There's no magic way to to do it. You're going to have a bunch of work in front of you. The easiest part is creating the blank database. 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
January 31, 2011 at 6:09 am
Perfmon is measuring the memory used. Task Manager is, I believe, showing you the size of the executable, not the memory allocated for 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
January 31, 2011 at 6:04 am
That's a formatting issue, not a data storage issue. You should deal with that on the client side, not in your database.
"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
January 31, 2011 at 6:00 am
Without using a third party tool, your only option is as described above, a full restore to a different location or a different database and then migrate the tool over.
You...
"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
January 31, 2011 at 5:59 am
free_mascot (1/31/2011)
Once transfer is done you...
"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
January 31, 2011 at 5:57 am
I would create a role to assign the users to and then assign that role to ddladmin, data_reader, data_writer, and security_admin for the database. That last role is probably 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
January 31, 2011 at 5:54 am
The hint when applied to a query will take precedence.
"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
January 28, 2011 at 1:10 pm
Wow... That's a rather large query. A couple of notes. You have NOLOCK all over the place. Yes, that prevents locking, but it can lead to bad data being returned...
"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
January 28, 2011 at 11:42 am
Abhijit More (1/28/2011)
nope I am finding out the ways we can beat the Operators.
You don't want to try to "beat the Operators." You want to try to work with 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
January 28, 2011 at 11:25 am
prakash_mc (1/28/2011)
Did you try new features (Schema / Data compate) available in Visual studio 2010 ?
Those have been available since the Visual Studio 2005 Team Edition. Decent tools. Really. Not...
"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
January 28, 2011 at 8:20 am
Glad I could help.
Yeah, 2008 you no longer have a choice on the JOIN syntax. Might as well jump.
Also, keep an eye out for opportunities to use UNION ALL instead...
"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
January 28, 2011 at 8:18 am
GilaMonster (1/28/2011)
sql_butterfly (1/28/2011)
As per my standards, the best execution plan should look like when you can see the 100% Index seek from a table (within a query).
I disagree. Only...
"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
January 28, 2011 at 5:50 am
This needs a ton of work to make it generic, parameterized, but if you guys want the raw form, this powershell script will automatically generate scripts for all databases on...
"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
January 27, 2011 at 7:02 pm
Viewing 15 posts - 13,441 through 13,455 (of 22,219 total)