Viewing 15 posts - 45,406 through 45,420 (of 49,552 total)
balbirsinghsodhi (7/28/2008)
How to estimate database recovery time in sql 2005.
How long is a piece of string?
Without a lot, lot more info, there's no way to say. I've had everything from...
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
July 28, 2008 at 10:08 am
Yup. I can see the problem.
Look over the example I posted above and look carefully at which variable have the _ and which don't. While I prefer the names 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
July 28, 2008 at 10:02 am
Are there any other queries running against table1? Inserts? Updates? Deletes?
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
July 28, 2008 at 10:01 am
select c.name, t.name from sys.columns c inner join sys.types t on c.user_type_id=t.user_type_id
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
July 28, 2008 at 5:20 am
Actually, you want to take a full backup after running this, as you are truncating the log and breaking the recovery chain. After running this you will not be able...
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
July 28, 2008 at 4:50 am
Please post table schema, index definitions and some of the more frequent queries
Talking about table optimisation in the abstract is difficult at best.
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
July 28, 2008 at 4:48 am
su_kumar11 (7/28/2008)
Could u please tell me how to start the server with traceflag 1400.
I would recommend that you don't and rather look at patching the server to SP2 at 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
July 28, 2008 at 4:21 am
Make sure they don't have any rights to the database. (and make sure they're not sysadmin)
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
July 28, 2008 at 4:20 am
I do hope you're taking a full backup afterwards, since you're also breaking your log chain doing this.
When you say "It's not working" What do you mean? Error? Not doing...
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
July 28, 2008 at 4:14 am
What did the xp_cmdshell return for him? I know it will work, I'm interested in what it shows when you try to do a DIR of the serverA.
What error are...
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
July 28, 2008 at 4:07 am
But if you put the database on each user's PC, then each user can only see their own information and not anything that anyone else adds/changes.
Is that what you...
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
July 28, 2008 at 4:04 am
Yes, there is. You can use the xp_msver extended procedure. I'm not sure of the security requirements
exec xp_msver 'ProcessorCount'
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
July 28, 2008 at 3:49 am
Shrinking a full database is a little pointless.
Shrink releases unused space to the OS, if a database is full then there is no free space inside it, hence all shrink...
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
July 28, 2008 at 3:43 am
Why are you putting the SQL database onto users PCs? Shouldn't it be on a central server?
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
July 28, 2008 at 3:36 am
Harish (7/28/2008)
Your table need to get repaired. If possible then recreate your table. or just run checkDB or dbcc checktable option with repair
Never run a checkDB or CheckTable with any...
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
July 28, 2008 at 3:36 am
Viewing 15 posts - 45,406 through 45,420 (of 49,552 total)