Viewing 15 posts - 36,076 through 36,090 (of 49,552 total)
Please don't shout at us (type all caps)
sp_configure 'Ad Hoc Distributed Queries'
There is a good reason this is disabled by default. Check with the DBA and whoever's responsible for security...
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
October 29, 2009 at 6:27 am
Sorry, I don't understand. I'm not saying drop the date column.
Define a computed (calculated) column, based on the effective date column then create a unique index on the computed column.
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
October 29, 2009 at 5:56 am
A restore recreates the database in exactly the same state it was at time of backup.
As for the index usage stats report, that sources off sys.dm_db_index_usage_stats. That DMV is memory...
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
October 29, 2009 at 5:47 am
Define a computed column as the year and the month, persist that column and stick a unique index on it.
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
October 29, 2009 at 5:43 am
Reported. Please do not download attachment
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
October 29, 2009 at 5:39 am
Silverfox (10/29/2009)
Can you confirm when the book comes out, the manning site says november the 4th and yet amazon says 13th december.
The first print run is going straight 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
October 29, 2009 at 5:19 am
CirquedeSQLeil (10/28/2009)
Anybody know anything more about it, opinions or otherwise?
Some background first.
Project was started late last year, it was open to all MVPs (regardless of technical speciality) providing they wrote...
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
October 29, 2009 at 1:32 am
Bob Hovious 24601 (10/28/2009)
Gail, can I get your autograph if I buy a copy? (I'm buying one anyway, but hey.)
Come to the launch event[/url], you'll find most of...
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
October 29, 2009 at 12:43 am
In detailed mode, there's a row for each level of the index (see monday's article on indexes if you're not sure what I'm talking about). In limited mode there's only...
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
October 29, 2009 at 12:41 am
I think half the problem with Sharepoint is that many companies implementing it have absolutely no idea why they want to implement it. They just want to have it because...
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
October 28, 2009 at 4:13 pm
CirquedeSQLeil (10/28/2009)
Anybody know anything more about it, opinions or otherwise?
I know a great deal about it. Would you be interested in my highly biased opinion? (I'm one of the authors...
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
October 28, 2009 at 3:48 pm
Eddie Hendrix (10/28/2009)
The basic question is: should a valid set of .MDF/.LDF files of the MSDB database be able to migrate, and come online, when moved from server to server?
Should?...
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
October 28, 2009 at 3:15 pm
shane2174 (10/28/2009)
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
October 28, 2009 at 1:23 pm
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic810071-17-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
October 28, 2009 at 10:16 am
Charles Kincaid (10/28/2009)
Gail: Are you going to talk about page overhead? (I hope. I hope. I hope.)
Not in an introductory article. Row header, null bitmap, slot indexes, page...
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
October 28, 2009 at 9:49 am
Viewing 15 posts - 36,076 through 36,090 (of 49,552 total)