Viewing 15 posts - 40,201 through 40,215 (of 49,571 total)
shishir999_ril (3/23/2009)
So, that query is acting as recurssive. Is there a way to change...
March 24, 2009 at 1:34 am
Vishal Singh (3/23/2009)
Although, I believe the REPAIR_ALLOW_DATA_LOSS command itself take the database in the SINGLE USER mode..:-)
It doesn't. You have to explicitly set the DB to single user mode before...
March 24, 2009 at 1:32 am
I mostly use the 'posts since last visit' and I'd like it to be able to contain a day or two's posts. I'm probably not going to read threads older...
March 23, 2009 at 2:50 pm
Steve Jones - Editor (3/23/2009)
Any suggestions for a setting?
What's the average number of threads that are posted to per day?
Maybe have the threshold different for the 3 recent...
March 23, 2009 at 2:43 pm
Tony Davis (3/23/2009)
Part of what I was wondering with this editorial was: what are the equivalent "classics" for the DBA?
For a classic, I'll vote for Ken Henderson's Guru's guide...
March 23, 2009 at 2:12 pm
Steve, it looks like all three of the recent posts options (since last visit, today and this week) are maxing out at 150 entries. Currently all three are showing me...
March 23, 2009 at 2:09 pm
Lynn Pettis (3/23/2009)
Steve, your presentation was well done, and you should start seeing me blogging soon.
Woot! :w00t:
Mail me the URL when you get it launched?
March 23, 2009 at 10:23 am
If you have 5 SQL instances on one machine (virtual or not), you need to limit their memory. SQL is a memory hog and will take as much as it...
March 23, 2009 at 9:27 am
vwilliams (3/23/2009)
I am having the same problem. I cannot change the compatibility level on the database because of older applications.
Also posted here - http://www.sqlservercentral.com/Forums/Topic681532-145-1.aspx
No replies to this...
March 23, 2009 at 9:25 am
If they have permission to query a view, then they'll be able to see the definition of it.
If they have any permissions at all on the object, then they...
March 23, 2009 at 9:07 am
Please don't cross post. It just wastes peoples time and fragments replies.
No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic681491-5-1.aspx
March 23, 2009 at 9:03 am
There are Performance tuning forums for both SQL 2000 and SQL 2005, likewise T-SQL. There's a forum for SSIS. Pick the forum that matches the version that you're using and...
March 23, 2009 at 9:03 am
Just one point on the datareader. You said that it can view objects, but not stored procedures. That's not technically true.
The way the system objects are set up, a user...
March 23, 2009 at 8:48 am
Oscar Fernandez (3/23/2009)
SQLServer has information for index that are not used.
That info's only since the last start of the SQL service. The data in the index usage DMV is not...
March 23, 2009 at 8:10 am
Please post in an appropriate forum in the future. The Website upgrade forum is for discussions and problems with the SQL Server Central web site.
March 23, 2009 at 8:00 am
Viewing 15 posts - 40,201 through 40,215 (of 49,571 total)