Viewing 15 posts - 13,171 through 13,185 (of 22,219 total)
GSquared (2/21/2011)
Grant Fritchey (2/21/2011)
And this post makes 10,000 points. On to getting 10,000 posts.Figured I'd break the threshold on The Thread.
Grats!
(For some reason, I keep thinking you were ahead 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
February 21, 2011 at 9:24 am
Whatever acts as the aggregate to get you the top 90% is also the thing that you can order by to get the first 50 using TOP 50 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
February 21, 2011 at 7:50 am
And this post makes 10,000 points. On to getting 10,000 posts.
Figured I'd break the threshold on The Thread.
"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
February 21, 2011 at 7:47 am
It really depends on what the needs of the project are. I tend to shy away from denormalization as a plan. I usually plan on normalizing with a standard design,...
"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
February 21, 2011 at 6:01 am
Further, employers will do internet searches based on your name. They can find this thread and will certainly be less inclined to hire someone as a trusted database manager who...
"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
February 21, 2011 at 5:53 am
I would strongly suggest you take a look at SQL Compare[/url] from Red Gate (yes, I work for them). But, you need to know, while SQL Compare works wonders, it's...
"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
February 21, 2011 at 5:49 am
I'm with Lutz. I think you'd be better off using an Identity column, even make that the primary key, and then have a calculated column or just put it into...
"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
February 21, 2011 at 5:43 am
I write a lot more TSQL than I click on the GUI. I mainly use the object explorer window to keep track of all the tables & columns, but other...
"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
February 20, 2011 at 8:54 pm
nico van niekerk (2/20/2011)
"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
February 20, 2011 at 7:05 pm
There are a lot ways you can go about working with developers on databases in a team environment. You'll have to figure out what works best for you. The one...
"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
February 20, 2011 at 4:14 pm
WayneS (2/20/2011)
@Grant, Steve, Jeff - any chance...
"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
February 20, 2011 at 4:09 pm
Hard to say, I don't know your systems or the volumes involved. I would only split to another database if I thought the load required 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
February 20, 2011 at 9:10 am
To connect to that, you have to supply the machine name as well as the instance name. MachineName\SQLServer from what you showed ought to do the trick. I suspect you're...
"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
February 20, 2011 at 5:45 am
I suspect everyone has their own best practice. I only break down schemas into either discrete security areas, where I'm going to treat some tables differently than others for security,...
"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
February 20, 2011 at 5:43 am
Just a side note, if your reindex jobs don't finish and you stop them, isn't the problem just going to spiral? Won't every night it get, maybe, just a little...
"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
February 20, 2011 at 5:39 am
Viewing 15 posts - 13,171 through 13,185 (of 22,219 total)