My server is 2000, and the KB is specific to 2005
i do not use DBCC INDEXDEFRAG. I have searched the sql server log for file autogrowth entry but could not find one. I did, however, find some...
over night we have DB backup, reindexing, integrity check, and some application specific jobs. I know the reindexing increases size of the log but...
the sizes i have stated were the total size of data and log file.
I have a database which has autogrow turned on and is set to grow 10%. My database was 228GB. my database grew last night to a size of 270GB. This...
I understand what the two statements (union and case) do. What i am trying to accomplish is have a conditional union statement that depending on...
I was wondering if there is a way to have the result of a case statement be a t-sql statement within a union? If not, is there another way to...
Is this a client application or a web application? If it is client you should be able to use windows authentication and add domain accounts or group...
If you truly do not trust system administrators to add themselves to groups or change passwords of windows user accounts then take the security out...
thanks for the help but I found a solution. I used sp_help_revlogin SP to create script of login on primary server which includes SID, which was the...
Since this is a log shipping destination database i cannot remove READONLY flag with ALTER DATABASE <database name> SET READ_ONLY because the...
I am still unable to figure out how to add a login on my destination server to be able to access the standby/read-only database. When I restore the...
I have a log shipped database that is in read-only mode. I wanted to add a new login to be able to access this database but since it is read-only...
I currently have SQL sever 2005 sp1 running on ESX 3.0.1 with the data files on raw LUNs. This database is quite basic in its function so it performs...
Thanks for all the suggestions. What I have decided with is to do batch deletions of 10000 at a time stopping every million to do trans log backup....
I had tried to run a delete on a table base on rows in another for archiving but the statement ran for over 3 hours and eventually failed because...
sure, exec <database>.<schema>.<procudure> ex master.dbo.sp_who
Thanks for your replies. I have changed the VendorID index to include both leadID and accepted which has changed the execution plan closer to what I...
The statistics and indexes are up to date ( I had updated both before posting). I have tested this a bit more myself and have found by changing a...
yes there is an index on received, there is also index on vendorID and the primary key is leadid.
Separate names with a comma.
