Viewing 15 posts - 44,536 through 44,550 (of 49,571 total)
Late to the party but...
rian67 (9/12/2008)
September 13, 2008 at 3:10 am
SQL 2005 ignores the TOP 100%... ORDER BY construct in views, as order by statement is only valid in the outermost select statement, unless a row limitation is in effect...
September 12, 2008 at 11:35 am
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...
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...
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...
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...
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.
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.
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...
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...
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...
September 12, 2008 at 7:24 am
What happens if you try doing the restore via T-SQL script?
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.
September 12, 2008 at 3:08 am
Viewing 15 posts - 44,536 through 44,550 (of 49,571 total)