Viewing 15 posts - 8,326 through 8,340 (of 14,953 total)
There are times that I give really short answers that basically amount to "here's the keyword you need to search online/in BOL". Even in those cases, I make it...
September 28, 2009 at 11:48 am
I just tried this and got the right results:
create table #T (
ID int identity primary key,
Dim int,
Val int);
insert into #T (Dim, Val)
select 1, 1 union all
select 1, 2 union all
select...
September 28, 2009 at 11:45 am
There isn't a single statement for it, but you could write a script that would do it all at once.
Would look something like this:
select
'alter table ' +
(select name
from...
September 28, 2009 at 11:39 am
The more you know, the harder it is to judge nuanced issues, but the more likely you are to judge correctly when you do get around to it.
Some things are...
September 28, 2009 at 9:38 am
There's a human tendency to see patterns in chaos. Sometimes we see real patterns, other times we just dub stuff in because we're wired to do so. Can't...
September 28, 2009 at 9:32 am
If your database is in Full recovery mode, you can get who/what/when on updates and such by using a log parser. ApexSQL has a good one, and I think...
September 28, 2009 at 9:15 am
These two articles and their discussions cover the subject pretty thoroughly. If you haven't already, you might take a look at them:
September 28, 2009 at 9:13 am
Deletes don't cause page splits. Inserts and updates that are out-of-clustered-sequence do.
If page splits and fragmentation are the problem you're working on, focus on inserts and updates that affect...
September 28, 2009 at 8:54 am
Jack Corbett (9/18/2009)
Select
From
table
Where
column between a and b AND
...
September 28, 2009 at 8:42 am
I may be misreading this, but if I understand you correctly, that's not precisely how fill factor works.
Data is stored in 8k pages. If you have small rows, like...
September 24, 2009 at 1:53 pm
Insofar as multiple instances running on the same binaries, I have to ask "why bother?"
The only reason I can think of to have multiple instances of SQL Server on the...
September 24, 2009 at 1:45 pm
It's a baseball reference.
Check this http://www.sqlservercentral.com/Forums/Topic447796-4-1.aspx for further discussion on the levels.
September 24, 2009 at 7:49 am
The linked article seemed more than a little self-serving and biased to me.
I've worked with a lot of IT people, and a lot of non-IT people, and the thing I...
September 24, 2009 at 7:41 am
Silverfox (9/23/2009)
Gianluca Sartori (9/23/2009)
If he insists killing processes without knowing what they do, let him do it.He already has decided to increase lock timeout and kill process, so, why bother?
Has...
September 23, 2009 at 10:05 am
Viewing 15 posts - 8,326 through 8,340 (of 14,953 total)