network profile
| bio | website | ryanbseattle.myopenid.com |
|---|---|---|
| location | Greater Seattle Area | |
| age | ||
| visits | member for | 2 years, 4 months |
| seen | Mar 11 at 21:54 | |
| stats | profile views | 10 |
SQL Server DBA
|
Jul 24 |
answered | SQL Server : CheckDB runs fast enough on one database, agonizingly slow on another |
|
Jun 30 |
answered | sql log backup expiration settings |
|
Jun 11 |
answered | How do I data warehouse a set of tables and delete the source? |
|
Jun 6 |
awarded | Supporter |
|
Jun 4 |
revised |
32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY? added 1 characters in body |
|
Jun 4 |
awarded | Revival |
|
Jun 4 |
revised |
32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY? added 189 characters in body |
|
Jun 4 |
awarded | Teacher |
|
Jun 4 |
answered | 32bit SQLServer with AWE NOT enabled. Buffer Cache Hit Ratio High, Disk Read Queue VERY HIGH, WHY? |
|
Jun 4 |
awarded | Scholar |
|
Jun 4 |
comment |
SET RECOVERY Model Using sp_msforeachdb Thanks a lot. I hadn't thought that the engine was still evaluating the SQL regardless of the condition. |
|
Jun 4 |
accepted | SET RECOVERY Model Using sp_msforeachdb |
|
May 31 |
comment |
SET RECOVERY Model Using sp_msforeachdb With the IF statement it returns the Name and DB_ID of each of the user databases. |
|
May 31 |
awarded | Editor |
|
May 31 |
revised |
SET RECOVERY Model Using sp_msforeachdb added 114 characters in body |
|
May 31 |
comment |
SET RECOVERY Model Using sp_msforeachdb I thought the same thing but adding the ? to the DB_ID check, or adding a USE ? to the parameter still produces the same error. |
|
May 31 |
comment |
SET RECOVERY Model Using sp_msforeachdb Thanks Kyle. I understand the reasons why doing this would cause an error. That wasn't really my question, though. Why am I getting the error at all, is the real question. |
|
May 31 |
asked | SET RECOVERY Model Using sp_msforeachdb |
