Viewing 15 posts - 47,791 through 47,805 (of 49,552 total)
karthikeyan (1/4/2008)
Actually, i want to know where exactly we need to use this BTW.
You've probably seen it in my posts. It's just the way I tend to write. You don'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
January 4, 2008 at 6:52 am
I'm sorry, I don't understand what you want.
Please read through this and give me some info so that I can help you.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 4, 2008 at 5:21 am
If you have log backups occuring you don't need or want to truncate the log. An explicit truncate will break the log chain and prevent restores to a point in...
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 4, 2008 at 4:51 am
If you include it in the from and don't do a join, you get what's called a cross join. Each row of the one table is matched to each row...
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 4, 2008 at 4:36 am
I'll go stronger than that.
Don't use dumps at all. It's cheating, it reduces the value of the certifications, and if you get caught, your certifications will all be revoked, permanently.
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 4, 2008 at 4:01 am
dedezana (1/4/2008)
FROM #TranID tId Join eft.[Tran] t on tId.id = eft.[Tran].TranID, dbo.StateJOIN Partner p ON t.partnerID = p.partnerID
Is the cross join to the State table intentional? If...
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 4, 2008 at 3:58 am
Can you post the function, the definition of the tables and the indexes on those tables please.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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 4, 2008 at 3:15 am
In that case, inx1 is unnecessary, since it is a left-based subset of another index.
I do recommend that every table gets a clustered index so maybe thins (NB, without any...
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 4, 2008 at 3:12 am
Could you post the query that you'e having problems with please?
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 4, 2008 at 3:03 am
Indexes on a table should be based on the queies that will be run against the table. There's no point in having an index on a column if there are...
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 4, 2008 at 2:42 am
Triggers are used when you want something to happen when rows are inserted, updated or deleted, regardless of where the data change came from (app, management studio, job,...)
Auditing 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
January 4, 2008 at 2:30 am
One thing I missedin your post.
A tran log backup doesn't shrink the log. It just truncates and discards the inactive portion of the log that it has backed up. 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
January 4, 2008 at 2:18 am
Pleasure. Are you all sorted now?
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 4, 2008 at 2:04 am
In my opinion, hyperthreading ahould not be enabled on a server that will be running SQL. Multi cores are fine.
Hyperthreading doesn't give two independent cores though SQL assumes them...
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 4, 2008 at 2:04 am
You should rebuild all your indexes after shrinking a database, as a shrink causes very high fragmentation. This rebuild will probably cause the databases to grow again.
The thing is, databases...
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 4, 2008 at 1:56 am
Viewing 15 posts - 47,791 through 47,805 (of 49,552 total)