Viewing 15 posts - 44,521 through 44,535 (of 49,552 total)
If there are multiple foreign keys and you need to look up the associated values, then what you've listed is what you do. You can't do a single join 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 12, 2008 at 11:11 am
Why use a trigger? What's wrong with a cascading delete on the foreign key?
Do you have nested triggers on? (right click the server in object explorer, select properties, go 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 12, 2008 at 9:28 am
Pretty much.
An extent is just that, 8 consecutive pages in the data file. After a table grows to a certain size (I think it's 24 pages in SQL 2005), then...
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 12, 2008 at 9:22 am
You asked...
The first 8 pages that are allocated to a page are allocated from mixed extents (extent = 8 consecutive pages). Once 8 pages have been allocated, then SQL 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 12, 2008 at 8:48 am
That table only has 3 pages in it. Don't worry about the fragmentation % for tables with less than 100 or so pages in 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
September 12, 2008 at 7:54 am
Brandie Tarvin (9/12/2008)
"Don't let that developer touch MY Database!!!!" @=)
With some of the developers I've worked with, that's a very rational fear.
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 12, 2008 at 7:50 am
Thomas Martin (9/12/2008)
What would cause this kind of behavior?
Has anything changed? Any index creates/drops? Any database settings changed?
It could be data volumes. The amount of data's increased and now 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
September 12, 2008 at 7:30 am
Grant Fritchey (9/12/2008)
Just a side note, a hash match isn't necessarily a bad thing. It can be the best way to retrieve the data, depending on the data involved.
Indeed. For...
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 12, 2008 at 7:28 am
Oblio Leitch (9/12/2008)
@Gail: Yes, I can post the query, but would it be useful?
It might be useful. There are certain constructs that can cause parameter sniffing or other similar...
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 12, 2008 at 7:24 am
What happens if you try doing the restore via T-SQL script?
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 12, 2008 at 3:11 am
I meant next time you post. Otherwise it'll be answered in both places with people suggesting stuff that's already been suggested.
Thread continues:
http://www.sqlservercentral.com/Forums/Topic568342-149-1.aspx
No replies to this thread 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
September 12, 2008 at 3:08 am
If all 300 of those logins are AD, then why do you want 300 matching SQL logins?
Add those logins to a domain group, grant the domain group login rights 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
September 12, 2008 at 2:54 am
Just be aware that multi-statement table valued functions tend to perform less then admirably, especially if they'll be returning lots of 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 12, 2008 at 2:00 am
Is there an entry in the 'blocked by' column? Is there a last wait type?
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 12, 2008 at 1:54 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please, direct replies to:
http://www.sqlservercentral.com/Forums/Topic568224-146-1.aspx
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 12, 2008 at 1:54 am
Viewing 15 posts - 44,521 through 44,535 (of 49,552 total)