Viewing 15 posts - 44,311 through 44,325 (of 49,552 total)
Molly Cary (9/22/2008)
Backups are scheduled every hour from 6am to 9pm
Full, diff or log backups?
Do you have any DB maintenance happening after 9pm (index rebuilds)?
What's the pattern of log...
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
September 22, 2008 at 9:31 am
What do the following two counters look like?
Physical disk: Avg sec/read
Physical disk: Avg sec/write
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
September 22, 2008 at 9:20 am
You can use profiler to see all the queries run against a server.
To check:
What recovery model is the DB in?
Do you have log backups running (not applicable if the above...
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
September 22, 2008 at 9:10 am
Duplicate post. No replies to this thread please. Replies to
http://www.sqlservercentral.com/Forums/Topic573532-5-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
September 22, 2008 at 8:26 am
No.
Databases cannot be downgraded in version (2008 to 2005, 2005 to 2000)
To get a SQL 2005 DB to SQL 2000 you'll have to script out the schema, bcp out 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
September 22, 2008 at 8:09 am
GSquared (9/22/2008)
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
September 22, 2008 at 8:00 am
webrunner (9/22/2008)
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
September 22, 2008 at 7:34 am
Depends how often it's used, how expensive it was to compile, how much memory pressure the server's under and a whole bunch of other stuff. The table's not a list...
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
September 22, 2008 at 7:13 am
vrailean (9/22/2008)
Like what kind of...? I would like a proper mentor/trainer on SQL ....
The book suggestion was for bhuvnesh, since he asked about certification notes.
I don't live 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
September 22, 2008 at 7:03 am
bhuvnesh.dogra (9/22/2008)
i also in queue with vrailean ...actually i want do SQL server certification 2005 ..can somebody give me some papaers or notes 🙂
The self-paced training kits from...
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
September 22, 2008 at 6:50 am
No, just the last diff, then the log backups from that diff up until the point of the dropped table.
Differential backups are cumulative from the last full backup.
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
September 22, 2008 at 6:47 am
You don't want to join in the where clause. It's an old join style and outer joins (which you need here) are not supported any longer.
Does this work?
SELECT entity_id,...
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
September 22, 2008 at 6:44 am
Where are you based in the world?
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
September 22, 2008 at 6:36 am
Should work. It definitely exists on SQL 2000. Maybe try prefixing with the master DB, though that shouldn't be necessary on SQL 2000, only on 2005 and higher.
select * from...
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
September 22, 2008 at 6:34 am
susantapattu (9/22/2008)
3. What will be the affect of adding a clustered & non clustered index on each and every column of a table consisting large no of rows?
Massive waste 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
September 22, 2008 at 6:29 am
Viewing 15 posts - 44,311 through 44,325 (of 49,552 total)