Viewing 15 posts - 19,891 through 19,905 (of 49,552 total)
What state is the database in at the moment? (state_desc in sys.databases)
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
March 6, 2012 at 9:28 am
Be patient. We're all volunteers, we all post in our spare time.
Apart from a few KB of memory, an idle process consumes no resources and has no effect on 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
March 6, 2012 at 9:24 am
Encrypt before you take the backup or encrypt after the restore. Can't be done during a restore, a restore recreates the database exactly as it was at time of 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
March 6, 2012 at 9:23 am
SQL trying and trying and retrying to grow the log and stopping any data modifications from running while it's trying to grow the 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
March 6, 2012 at 9:21 am
Your autogrow is too large for the disk subsystem to complete. As the error says: "Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly...
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
March 6, 2012 at 8:33 am
Yes, that or upgrade to 64-bit SQL
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
March 6, 2012 at 8:32 am
Admingod (3/6/2012)
(my understanding is 32 bit enterprise will take max memory of OS without need to enable AWE?).
Without AWE enabled 32 bit SQL (regardless of edition) can use no 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
March 6, 2012 at 8:18 am
Insert into t2 (col1,col2,col3)
select
col1,
Col2,
@Variable
from t1
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
March 6, 2012 at 7:19 am
anthony.green (3/6/2012)
also a primary key cannot contain a NULL value, but a UNIQUE constraint can contain 1 row which is NULL
Unless the column the unique constraint is defined on is...
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
March 6, 2012 at 5:47 am
deepikamm (3/6/2012)
I guess we can also use unique not null to enforce referential integrity
You can, yes. SQL is quite happy for a foreign key to reference a unique index,...
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
March 6, 2012 at 5:46 am
Limit the application account to minimal permissions and ensure that all ad-hoc and dynamic SQL is parameterised. Done properly, those two make a app completely immune to SQL Injection
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
March 6, 2012 at 5:12 am
Can you post the actual procedure?
When it runs forever, what's the query waiting for? (check sys.dm_exec_requests
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
March 6, 2012 at 5:10 am
prettsons (3/6/2012)
If this is the case, you will have to clean the database to remove the inconsistencies and then attempt to execute the DBCC command again.
Except this is 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
March 6, 2012 at 5:05 am
If IO and CPU are increasing then it is working. There are some database structures (heaps, LOB columns) that cause shrink to run slow, you just have to be patient.
Don't...
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
March 6, 2012 at 12:36 am
Overall performance (everything's slow) or erratic performance (usually fine, but occasionally not)?
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
March 6, 2012 at 12:33 am
Viewing 15 posts - 19,891 through 19,905 (of 49,552 total)