Viewing 15 posts - 38,086 through 38,100 (of 49,552 total)
hi_abhay78 (6/29/2009)
First take the database into emergency mode and then try to rebuild the index .
Emergency mode is for recovering a database that's suspect.
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
June 29, 2009 at 4:49 am
Compatibility mode 80?
Edit: Never mind. Ignore this. I misread the forum this was in.
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
June 29, 2009 at 4:48 am
venu_ksheerasagaram (6/29/2009)
2)Is the differential backup depends on the full backup file?
No, but you need both to restore a database
3)Suppose the full backup of the DB is not existed (or) moved...
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
June 29, 2009 at 4:47 am
Rebuild's not going to help. There's damage to the clustered index (ie the table itself). That's not redundant data hence there's nowhere for an index rebuild to read the damaged...
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
June 29, 2009 at 4:46 am
Why do you want to shrink? Databases tend to grow as more data gets put in them. It's in their nature.
Shrinking causes massive fragmentation and will just result in 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
June 29, 2009 at 4:44 am
Ramji (6/29/2009)
I need a script which should take a integer as input parameter(time in minutes), and should query sysjobs, sysjobhistory to check whether there is a mintanence window possible...
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
June 29, 2009 at 4:36 am
Grant Fritchey (6/29/2009)
You're right about the DROPCLEANBUFFERS and FREEPROCCACHE.
Personally I prefer to run all test queries twice and ignore the times of the first result. That way, what I'm seeing...
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
June 29, 2009 at 4:29 am
keil.asta (6/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
June 28, 2009 at 12:18 pm
Well, first you need to tell us what you consider to be the 'first' value. Tables have no order, so any row is equally valid as the 'first'
Why would row...
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
June 28, 2009 at 11:54 am
Then you should use the execution time from statistics IO or the duration from profiler as it includes all the times that SQL had to wait while executing that query....
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
June 28, 2009 at 11:48 am
Are things like IO latency (when fetching data off disk), lock wait times and the like relevant, or are you just looking for the amount of timethe queries spent executing...
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
June 28, 2009 at 10:57 am
rw30 (6/28/2009)
then the only way to know server side query execution time is to run SSMS on the server ? right ?
Or with a fast network where SQL's not going...
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
June 28, 2009 at 10:05 am
Was that via profiler or SSMS's query execution time (bottom right). The latter does include network trip time and everything as it's a display of the time until management studio's...
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
June 28, 2009 at 9:19 am
rw30 (6/28/2009)
GilaMonster (6/28/2009)
SET STATISTICS TIME ONand then run your query. There will be fairly detailed time breakdowns in the messages pane.
results shown after enabling SET STATISTICS TIME are almost...
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
June 28, 2009 at 8:51 am
SET STATISTICS TIME ON
and then run your query. There will be fairly detailed time breakdowns in the messages pane.
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
June 28, 2009 at 8:26 am
Viewing 15 posts - 38,086 through 38,100 (of 49,552 total)