Viewing 15 posts - 1,396 through 1,410 (of 2,496 total)
IMHO you need to make the update processing asyncronous to the user input. If you tie up a user screen for even 1 minute while you process their input,...
April 2, 2009 at 2:45 am
Also get the updates done by stored procedures on the server. That way you do not have to ship data to the client.
The only dat ayou should ever ship...
April 1, 2009 at 5:11 am
Reorganizing or rebuilding a cluster index does not have any impact on the non-cluster indexes in SQL Server 2000 SP4 or above, or any version of SQL 2005 or 2008....
April 1, 2009 at 5:07 am
Nobody else has said this yet, but your Errorlog sample does not show any sign of a memory leak.
What it does show is that SQL Server is unable to get...
April 1, 2009 at 5:02 am
What do the SQL Server install logs say about this? They should confirm if the second instance was installed, and may give a clue as to what caused the...
April 1, 2009 at 4:50 am
Please read what Books Online says about Transaction Logs, and what a transaction log backup means.
The command you want to do does not take a backup of the transaction log....
March 27, 2009 at 3:40 am
The suggestion to have 8 equal size files with 7 set to fixed size and 1 allowed to autogrow is good but does have its problems.
The biggest problem is if...
March 25, 2009 at 3:56 am
The situation with NTFS restrictions is similar to what is happening in SSRS. You can deny the local Administrators from accessing your files, but you cannot prevent them adding...
March 24, 2009 at 5:55 am
Yes, you cannot totally block local Administrators, but you can tell by the smell if they have been around. A DBA can check if unexpected logins are present, and...
March 24, 2009 at 4:37 am
I have looked at this on SSRS for SQL Server 2008, hopefully it will not be too much different for SSRS 2005.
As other people have said, you can add another...
March 24, 2009 at 4:24 am
Sorry, the command is not ALTER TABLE.
It is CREATE INDEX ExistingTable.ExistingIndex ON NewFilegroup WITH (DROP_EXISTING=ON)
See BOL CREATE INDEX (Transact-SQL).
March 23, 2009 at 9:20 am
...and they may have run the install from the Tools CD or folder instead of the Server CD or folder. 🙂
March 23, 2009 at 5:15 am
If you add an additional file to an existing file group, you have no control over what data SQL Server will put in the new file.
When any existing database object...
March 23, 2009 at 5:11 am
A good rulle of thumb is 'never shrink a database if you expect it to grow again within 3 months'. There can be exceptions to this, but you should...
March 23, 2009 at 4:59 am
Viewing 15 posts - 1,396 through 1,410 (of 2,496 total)