Viewing 15 posts - 47,296 through 47,310 (of 49,552 total)
Your colleague may be thinking about the NOEXPAND hint. That's onlty useful if you have indexed views and a version of SQL other than enterprise.
I would not recommend the use...
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 25, 2008 at 12:31 am
Nicely said Jeff.
I always go above and beyond what's expected. If I see a problem with a system I make an effort to fix it, or get it fixed. 'Good...
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 25, 2008 at 12:09 am
That's a very, very small table. 48k = 6 pages, less than an extent. Fragmentation doesn't have much meaning on such small tables.
I wouldn't worry about fragmentation except on bigger...
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 24, 2008 at 11:52 pm
Jeff Moden (2/23/2008)
That's kinda the conclusion I came to. Thanks for the great explanation, Gail.
Glad to be of help.
You don't happen to have a good URL for how 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
February 24, 2008 at 11:44 pm
How big is that table? How many pages?
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 23, 2008 at 11:09 am
Drop the snapshot and create a new one?
Perhaps I'm misunderstanding you, but after you've created a snapshot, neither new data nor new objects created after that time will be reflected...
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 23, 2008 at 8:06 am
Jeff Moden (2/22/2008)
And this isn't even parameter sniffing because it's a script!
It's caused by the same thing. When the optimiser gets a query, it knows the value of any parameters...
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 23, 2008 at 8:00 am
It's the name listed in sysindexes. (From the list you gave earlier, all the ones like _WA_s_....)
SELECT name FROM sysindxes WHERE INDEXPROPERTY(id, indid, 'IsStatistics') = 1 will give you 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 23, 2008 at 7:48 am
The cost % is the optimiser's estimate of how expensive an operation is relative to the rest of the query. If you have a table scan of a very small...
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 23, 2008 at 7:45 am
I would strongly suggest that you store the date as a date time and do the conversion/formatting in your query/view.
Timestamp is used for row versioning, as the value changes whenever...
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 22, 2008 at 4:16 am
Why do you want to store the date as a formatted string?
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 22, 2008 at 2:34 am
True. I should read more carefully.
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 22, 2008 at 2:15 am
Use a datetime. Format is a function of how you retrieve the data, not how you store it.
Look up Convert for a list of the formating options for datetimes.
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 22, 2008 at 2:12 am
Could you add a TOP 1?
SELECT TOP 1 f.forumid, forumname
FROM Forums f
LEFT JOIN Threads t ON f.forum_id=t.forum_id
LEFT JOIN (SELECT forum_id, MAX(postdate) as last_postdate FROM Threads GROUP By...
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 22, 2008 at 1:33 am
Despite its name, the timestamp datatype has nothing to do with times. It's a binary rowversion.
It you're wanting to store the date that the rows was inserted, then you need...
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 22, 2008 at 1:23 am
Viewing 15 posts - 47,296 through 47,310 (of 49,552 total)