Viewing 15 posts - 47,491 through 47,505 (of 49,552 total)
TheSQLGuru (2/1/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
February 1, 2008 at 1:07 pm
Rob Reid (1/31/2008)
3. At what number of indexes on a table does it become total overkill.
There's no hard and fast number. It depends on the datba and the data....
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
February 1, 2008 at 6:07 am
Unused = free
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
February 1, 2008 at 5:19 am
Yup.
The whole issue of 'most selective column first in an index' is a bit misleading. SQL can, and does, do multi-column seeks as one operation. What you want is the...
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
February 1, 2008 at 5:07 am
With a clustered index, the leaf pages of the index are the data pages. Yes, they are in the order of the index keys.
This means that the clustering key...
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
February 1, 2008 at 2:54 am
litu deb (2/1/2008)
I know how to shrink whole database and also individual file.
DBCC shrink database to shrink the whole database. DBCC ShrinkFile to shrink individual files
I would like to know...
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
February 1, 2008 at 1:23 am
Give this a try. Plese note, it is untested. I don't have your tables or data. It passes a syntax check, but that's all I could do.
Changes are in red.
Select...
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
February 1, 2008 at 1:11 am
I'm sorry, I'm not sure I understand your question.
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
January 31, 2008 at 11:49 pm
Give me SP3!
We're currently pushing to get the 5th cumulative update on one of our servers (cause we keep running into a problem that was fixed in SP2 and fixed...
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
January 31, 2008 at 11:30 pm
SELECT @NoFeaturedJobs = count(JobPK)
FROM JOBS
WHERE ClientFk = @ClientPK AND
SiteFk = @SitePK AND
FeatureScore BETWEEN 1 AND 5 AND
Live = 1
In general, for covering indexes, you want the columns in the following...
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
January 31, 2008 at 11:24 pm
Tony (1/31/2008)
From SQLHelp.Such as looks like SSMS always have ClientProcessID = 1000, true?
No. Depends on what other apps are running on the client, and when SSMS was started. Open task...
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
January 31, 2008 at 11:07 pm
Jeff Moden (1/31/2008)
However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of...
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
January 31, 2008 at 11:04 pm
You can only have 1 primary key per table, but you can have many unique keys
Primay keys cannot have nulls. A unique key defined on a nullable field can have...
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
January 31, 2008 at 10:41 pm
Matt Miller (1/31/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
January 31, 2008 at 10:23 pm
You could revoke all the table permissions and insist that all data access is via stored procedures. In the stored procs you can check the application name. You can also...
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
January 31, 2008 at 1:33 pm
Viewing 15 posts - 47,491 through 47,505 (of 49,552 total)