Viewing 15 posts - 43,366 through 43,380 (of 49,552 total)
Your index is very, very slightly fragmented (logical scan fragmentation. Lower is better) and the pages are 90% full (Avg. Page Density. Close to 100% is usually better)
All in 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
November 3, 2008 at 1:31 pm
los (11/3/2008)
Given that each subsequent diff backup contains all the changes since the last full backup, is it necessary to keep the previous diff backups?
It's a good idea. What...
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
November 3, 2008 at 1:03 pm
muhammed_annaggar (11/3/2008)
the problem is the permissions are removed when attaching a database to an other server.Muhammad
Which permissions?
SQL's permissions work at 2 levels. There are the database-level permissions which are related...
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
November 3, 2008 at 1:02 pm
Top 1 not necessary in an exists. Exists just checks if there's any rows or not, it doesn't care how many rows. Remove the top 1 and the behaviour 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
November 3, 2008 at 12:57 pm
Marios Philippopoulos (11/3/2008)
Yes, we have collected these perfmon counters, and from the values it appears there is indeed latency in the PROD-SAN drive.
Surprise surprise (not). Is it sharing drives 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
November 3, 2008 at 9:33 am
mduffy (11/3/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
November 3, 2008 at 9:30 am
2GB is tiny for a database. I've mirrored a 600GB one without issues (on a LAN). If you're planning to do it over a WAN, watch out. Other thing to...
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
November 3, 2008 at 9:21 am
muhammed_annaggar (11/3/2008)
Do you know what is happen internally in the server when a user attaches a database, i.e. is there any procedures called or any thing...
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
November 3, 2008 at 9:14 am
To get the latest 100 rows, you need some column that stores the date that the row was inserted, or you need an identity column (or a uniquidentifier with 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
November 3, 2008 at 9:08 am
Please don't start a new thread for an existing problem. People who encounter it without reading the original won't have a clue what's going on.
What's the setup, what's 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
November 3, 2008 at 9:05 am
Consider Transparent Database Encryption in SQL 2008. It's not username/password, but it will prevent a database from been attached/restored unless the appropriate certificate is on the destination server.
Now, if someone...
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
November 3, 2008 at 9:04 am
You can't alter the system resourse database. It's not visible and can't be modified. In SQL 2005, the files must be in the same location as master.
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
November 2, 2008 at 11:56 pm
gints.plivna (11/2/2008)
So AFAIK as Jeff already said in this case TOP 1 without order by functionally does the same.
Providing you don't mind which rows you get back, yes.
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
November 2, 2008 at 12:38 pm
All that means is that you can't use the STOPAT command if there was a bulk operation within the log backup that covers the time requested.
If log backups occur at...
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
November 2, 2008 at 5:53 am
Run the log backup job every 15 min from midnight. That's probably the safest way. Log backups aren't blocked by full backups in SQL 2005. even if they were, 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
November 2, 2008 at 1:58 am
Viewing 15 posts - 43,366 through 43,380 (of 49,552 total)