Viewing 15 posts - 39,526 through 39,540 (of 49,552 total)
Take it offline. If you make the DB single user there's a chance that someone will grab that single connection before the restore starts.
ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK...
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
April 24, 2009 at 6:21 am
Please ask your DBA to run the upgrade advisor on the database that you want to upgrade. It will pick up most (as I recall) of the issues.
Also see here...
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
April 24, 2009 at 6:15 am
sharanurampur (4/24/2009)
I got the solution for that one, its SQL problem, I don't know whether the solution is correct or not,now my database is working fine,
Mind...
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
April 24, 2009 at 3:41 am
If you want to split a backup over two devices, you can specify 2 (or more) destinations and the backup will be striped across those. Note that you need all...
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
April 24, 2009 at 3:01 am
Unless you had a trace running when that happened, I don't believe there's any way to find that information.
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
April 24, 2009 at 2:38 am
Have you run the SQL 2005 upgrade advisor?
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
April 24, 2009 at 2:36 am
Can you post the update statement and the trigger code 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
April 24, 2009 at 2:35 am
http://sqlinthewild.co.za/index.php/2008/07/08/what-is-a-deadlock/
As for timestamp, have a look in Books Online. There's a lot of info on timestamp there.
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
April 24, 2009 at 1:12 am
fayilt (4/23/2009)
Did I get that right - if I call DBCC DROPCLEANBUFFERS without calling CHECKPOINT, there is a risk of data loss?
No, not at all.
DROPCLEANBUFFERS, as it's name says will...
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
April 23, 2009 at 2:19 pm
Normalisation?
http://www.sqlservercentral.com/Forums/Topic703573-149-1.aspx
It's all yours. I'm headed for bed.
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
April 23, 2009 at 2:11 pm
Sample data?
Desired output?
Regarding normalisation, read these -
http://msdn.microsoft.com/en-us/library/ms191178.aspx
http://en.wikipedia.org/wiki/Database_normalization
http://support.microsoft.com/kb/283878
http://www.databasejournal.com/sqletc/article.php/1428511/Database-Normalization.htm
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
April 23, 2009 at 2:10 pm
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
By the sound of it you have a...
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
April 23, 2009 at 1:47 pm
If you want to compare physical reads you need to clear the data cache, not the procedure cache.
Checkpoint
DBCC DROPCLEANBUFFERS
The checkpoint will write all dirty (modified) pages to disk. The DROPCLEANBUFFERS...
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
April 23, 2009 at 1:44 pm
Naveen Kumar Tiwary (4/23/2009)
If I am going for a Cluster Index can I include a extra column to that as suggested?
It won't be necessary. Take a look at the architecture...
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
April 23, 2009 at 1:07 pm
Physical reads = from disk
Logical reads = from 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
April 23, 2009 at 1:06 pm
Viewing 15 posts - 39,526 through 39,540 (of 49,552 total)