Viewing 15 posts - 44,506 through 44,520 (of 49,552 total)
You can use DROP USER to remove database users
If you can explain a bit more about your problem, someone will be able to help you 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 15, 2008 at 1:56 am
Alter Index ... Rebuild
You can get all the details of the various options from Books Online
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 15, 2008 at 1:55 am
SQL Server does that automatically. If a user is updating a row then that row is locked exclusive and cannot be read or changed by anyone else.
Have I misunderstood 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
September 15, 2008 at 1:50 am
If the DB is in full recovery, then the log backups probably won't be able to run due to the single user mode.
If the DB is in simple recovery, then...
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 15, 2008 at 1:46 am
There's a proportional fill algorithm that's used. It doesn't matter what the file's max size is, just how much free space is in the files.
If you have three files...
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 14, 2008 at 10:52 am
Please find the SQL error log on the rebuilt node and have a look at what it says. Providing the service is getting started at all, there should be 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
September 14, 2008 at 10:49 am
jerryhung (9/13/2008)
so my next step is perhaps change all TABLE VARIABLE -> TEMP...
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 14, 2008 at 2:20 am
rian67 (9/13/2008)
According to the job description of DBA, they are responsible for Security, Performance, Recoverability, High Availability of RDMS. For...
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 13, 2008 at 7:52 am
And check that there isn't a job somewhere that runs shrink on a regular basis
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 13, 2008 at 3:29 am
I'll give it a try, however, since the policies are implemented as DDL triggers behind the scenes, I don't think it's possible.
Are you talking about a policy that prohibits 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
September 13, 2008 at 3:26 am
Table variables has the same scope as normal variables. Much less than a temp table. Their lifetime is limited to one set of commands (batch) sent to the server.
So,...
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 13, 2008 at 3:16 am
Excellent. Glad you came right.
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 13, 2008 at 3:10 am
Late to the party but...
rian67 (9/12/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 13, 2008 at 3:10 am
Happy birthday Steve
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 12, 2008 at 12:22 pm
SQL 2005 ignores the TOP 100%... ORDER BY construct in views, as order by statement is only valid in the outermost select statement, unless a row limitation is in effect...
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 12, 2008 at 11:35 am
Viewing 15 posts - 44,506 through 44,520 (of 49,552 total)