Viewing 15 posts - 44,806 through 44,820 (of 49,552 total)
It's not a different type of index.
An index is a covering index for a specific query if all of the columns that the query needs are included in the index...
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
August 28, 2008 at 2:05 am
If I'm understanding you corectly, you want the following script generated:
CREATE TABLE TableName (iPhotoGalId INT PRIMARY KEY IDENTITY(1,1) NOT NULL,vPhotoGalTitle VARCHAR(50),dModifiedDate DATETIME DEFAULT GETDATE(),iOrder INT)
but you're getting this:
iPhotoGalId INT Primary...
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
August 28, 2008 at 1:51 am
joemai (8/27/2008)
you can also backup the transaction with truncate or no_log option:backup log your_db with truncate_only
Since the DB is in Simple recovery mode, a checkpoint will truncate the log and...
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
August 28, 2008 at 1:46 am
One of the drawbacks is in terms of security. Using dynamic SQL requires that the user has rights to the base tables and opens the system up to possible SQL...
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
August 28, 2008 at 1:40 am
No matter what settings you use, SQL will log transactions. It's not an optional part of the system, it's how data integrity is guaranteed. Data changes are first written 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
August 27, 2008 at 2:37 pm
Marios Philippopoulos (8/27/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
August 27, 2008 at 11:58 am
Marios Philippopoulos (8/27/2008)
"At present, the missing index information...
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
August 27, 2008 at 11:38 am
day (8/27/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
August 27, 2008 at 10:45 am
Why does it have to be clustered? If it was me, I'd suggest a nonclustered index for that, (TN, CID) INCLUDE (IDt)
What's the selectivity of TN? How many 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
August 27, 2008 at 10:39 am
Marios Philippopoulos (8/27/2008)
One caveat is that indexes used in places other than in the WHERE clause of queries are not included in the DMVs, so, for example, indexes needed on...
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
August 27, 2008 at 10:37 am
Depends whether you're going for per CPU or per seat licencing. Per CPU licences are a lot more expensive, so if you don't have a large number of users, consider...
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
August 27, 2008 at 10:27 am
jlp3630 (8/27/2008)
I'm running RAID-0 on my c: drive (contains Windows, SQL server, master, model and msdb databases and log files).
I'm running RAID-50 on my f: drive (tempdb, user databases and...
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
August 27, 2008 at 10:13 am
SQL does not have a mind of its own. It will not change a database's recovery model unless someone issues a command to do so.
Check any jobs that run...
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
August 27, 2008 at 10:04 am
Ahmad Osama (8/27/2008)
wait type is pageiolatch_sh....
Then it is databaseID : FileID : PageID
Is there any chart to get this depending on the waittype....
or any logic
I've seen one before, I can't...
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
August 27, 2008 at 2:48 am
For this kind of error, you should probably contact Microsoft's customer support people. We don't have the tools to read stack dumps and figure out what caused them.
Generally, it'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
August 27, 2008 at 2:35 am
Viewing 15 posts - 44,806 through 44,820 (of 49,552 total)