Viewing 15 posts - 44,191 through 44,205 (of 49,552 total)
One other misconception. A clustered index scan is not better than a table scan. It's the same thing. It's called a table scan when run on a heap (table without...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 1:40 pm
SanjayAttray (9/26/2008)
Nothing I am aware of in SQL Server 2000. Use this for 2005.
How is that going to find indexes that the queries never use?
In SQL 2000, there's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 1:35 pm
There are some cases where the 2005 optimiser produces worse plans to the 2000 one. Short of a rewrite or query hints, there's not way to force the optimiser to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 1:08 am
Not sure why you're getting an access violation. What do the procs do? Any linked servers involved?
There is another issue with the trigger
select
@status ...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:57 am
How are you restoring? What options have you checked?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:49 am
SELECT dateadd(dd, datediff(dd,0, getdate()),0)
The varchar method works, but is slower. See - http://sqlinthewild.co.za/index.php/2008/09/04/comparing-date-truncations/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:48 am
RAJNISH AWASTHI (9/25/2008)
Wanted to know that :-
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:47 am
Check out Paul's blog post on attaching corrupt databases. It may help you. If you get problem, post in the corruption forumn here (the SQL 2000 one) as Paul sometimes...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:44 am
I'm no AD expert, however those are not SQL-related errors. They point at a problem communicating with the DC. If that was my server, I'd be passing those over to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 26, 2008 at 12:41 am
Steve Jones - Editor (9/25/2008)
I thought Gail was right here. Shouldn't use space for int/char if it's null, the null bitmap should carry that.
That's how I thought the null bitmap...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 11:06 am
Matt Miller (9/25/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 10:59 am
Matt Miller (9/25/2008)
GilaMonster (9/25/2008)
Matt Miller (9/25/2008)
On other (non-variable length) columns, such as int, the space is still allocated even when the Bit map is set.
I don't think they are. Will...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 10:57 am
Robert klimes (9/25/2008)
Is there something that I am overlooking that is causing this, or do nulls take up some space?
Don't forget that the row headers and footers do take some...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 10:48 am
But it's not going to be 42 GB for a million rows.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 10:39 am
Arthur.Lorenzini (9/25/2008)
Doesn't creating the FK back it up with an index?
No. As I said, foreign keys are not indexes.
Primary keys are enforced by indexes, it's the only way to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
September 25, 2008 at 10:37 am
Viewing 15 posts - 44,191 through 44,205 (of 49,552 total)