Viewing 15 posts - 10,726 through 10,740 (of 49,552 total)
Update statistics on a table updates ALL statistics on that table, index and column alike.
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
December 5, 2013 at 11:42 pm
I thought I remembered object_Id working. Hmmm...
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
December 5, 2013 at 7:38 am
There are, but what's wrong with running profiler (or preferably a server-side trace) and recording the duration 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
December 5, 2013 at 7:04 am
sys.columns 🙂
Table variables have their columns recorded in the TempDB system tables just like any other table. They're a little harder to identify because the table name is changed. Edit:...
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
December 5, 2013 at 7:02 am
ChrisM@Work (12/5/2013)
Drum rolls with chocolate.
Hmm.. I wonder what chocolate drum rolls taste like. :hehe:
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
December 5, 2013 at 6:40 am
How are you restoring it? If the backup was taken via Red Gate's SQL backup, it needs to be restored via Red Gate's SQL backup. If you're already doing that,...
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
December 5, 2013 at 6:04 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/Topic1519944-392-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
December 5, 2013 at 4:30 am
The database you're using is corrupt. Call your DBA and tell him there's corruption in the database.
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
December 5, 2013 at 3:44 am
It means enough of the transaction log so that the restore can recreate the database in a transactionally consistent way. Don't worry about what from what file, just focus 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
December 5, 2013 at 2:32 am
A differential backup is a backup of the data changes since the last full backup. It's a data backup, not a log backup, so mostly the data file with enough...
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
December 5, 2013 at 12:09 am
durai nagarajan (12/4/2013)
Will DB in norecovery mode accepts "Set to read only" command?
No, because it's inaccessible (can't be read or written). However in the list above, 'set to read 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
December 4, 2013 at 11:45 pm
In unrelated news, slightly belated drum rolls 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
December 4, 2013 at 10:36 pm
MohamedDBA (12/4/2013)
I mean what is a publisher from your perspective as a SQL Server professional produce a good collections of books in SQL Server you prefer it
All of 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
December 4, 2013 at 8:59 am
MohamedDBA (12/4/2013)
What is your favorite books for SQL Server study , and tell us why please
Those aren't books, they're publishers.
Favourite books: Inside SQL Server 2008 (soon to be replaced with...
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
December 4, 2013 at 8:16 am
Table definitions and index definitions 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
December 4, 2013 at 6:48 am
Viewing 15 posts - 10,726 through 10,740 (of 49,552 total)