Viewing 15 posts - 44,551 through 44,565 (of 49,552 total)
Have a look at the PIVOT keyword in SQL 2005. It may help with what you're trying to do.
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 11, 2008 at 8:36 am
Then what you're trying to do is impossible with backups.
To allow the users to write, the last backups needs to be restored with recovery. That means to apply any more...
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 11, 2008 at 8:34 am
Have a look at this:
http://www.sqlskills.com/blogs/paul/2008/01/31/MoreOnHowMuchTransactionLogAFullBackupIncludes.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 11, 2008 at 8:28 am
GSquared (9/11/2008)
To my understanding, they didn't actually perform any collisions yesterday, they just fired some particles around in a circle to make sure it was working.
They did some collisions, but...
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 11, 2008 at 8:28 am
Depends what you need the secondary to be doing. Read-only or read-write?
If you can consider an upgrade to 2005, you could use database mirroring with a snapshot on the mirror...
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 11, 2008 at 8:26 am
There's not really anything like that, because all of the operators have their places and times when they are optimal.
You could read through Grant Fitchley's book on exec plans. Last...
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 11, 2008 at 8:19 am
Because sometimes the SQL Service needs to be able to access resources other than on the local machine. Other SQL Servers, other database servers, file shares, etc.
If you make local...
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 11, 2008 at 8:11 am
You can apply the diff with NORECOVERY/STANDBY as well, but it means that the DB will either be completely inaccessible (norecovery) or readonly (standby)
If you want to bring the DB...
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 11, 2008 at 8:00 am
mattjk (9/10/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 11, 2008 at 7:57 am
Are you perhaps trying to restore a 2005 database to SQL 2000?
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 11, 2008 at 7:01 am
Unless you have some form of auditing already in place, you won't be able to see what happened. The error log just stored details of errors and informational messages.
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 11, 2008 at 6:27 am
For the third time, the maximum limit to concurrent connections in SQL Server 2005 is 32767.
The value that you see under the server properties - connections can be set by...
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 11, 2008 at 6:20 am
Merge replication != minimal overhead. In my experience, it's the type of replication that puts the most load onto the servers. It sounds like what you want is peer 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
September 11, 2008 at 6:14 am
Any chance of duplicate dates?
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 11, 2008 at 6:12 am
A covering index is an index that contains all the columns that a query references. An index may be covering for one query and not for another.
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 11, 2008 at 5:17 am
Viewing 15 posts - 44,551 through 44,565 (of 49,552 total)