no activity is happening on the databases expect the create index command. database is set to auto grow and it has enough space on the drive Index is...
No, there is no users connected to the database during the index creation window. User are locked out of the database.
Yes, its all non clustered indexes.. creating indexes in windows time mean? i didn't understand this ? wha you mean creating index in windows time ??
Issue: Index creation is taking longer time than the usual timing, there were no changes on the SQL server and the server. All of the sudden on most...
Hi, I use the below script to take litespeed backup and restore. Even though if i mention the STATS parameter i dont see the status during the backup...
<p> here you go... earlier database size was 6GB after rebuild index the size is 21gb. </p><p>This is happening for all the databases if run...
Yes, Log file is in simple recovery model.. it remains the same size, only the data file file has increased to 24GB from 4GB.
I ran a rebuild index on 4GB size databases, after the rebuild index the database has grown upto 24GB. Only the data file has grown bigger. when i...
Can some one provide me the script for xp_servicecontrol undocumented storeprocedure. Or do we have any procedure to verify the status of SQL...
refer the below link... http://www.microsoft.com/sql/techinfo/whitepapers/advantages-64bit-environment.mspx Raghu
Yes, by creating the SQL user i am able to access the SQL server from both the servers, but i am not able to access files from OS. Is it possible to...
Yes, you are right. Since the SQL servers are in two different domain i can grant permission to the service account, also i am connecting the other...
I have a share drive mapped as F to one of the servers using a specific login account. I am able to access the mapped drive in command prompt using...
Satya, Tempdb data file is growing up. The size of the data file is 5GB and unallocated free space on it is 5GB, if try to shrink the space is not...
On one of my SQL server 2005, tempdb has grown upto 35GB and its still growing up. tempdb has 34GB as unallocated free space, so i tried to shrink...
Is it possible to restore a SQL server 2005 database on SQL server ? I took the backup 2005 database by changing the compatability level to 80 and...
Delete the old database owner login and try to change the owner to new one and then add the old login if required.
Use the below command to kill all the processes select ' kill ' + convert(varchar, spid) from sysprocesses where spid > value copy the output of the...
Hi Satya, Yes, SQL agent is dependent only on Master & model only. But After SQL server recycle the agent will be up but it will accessible untill...
Hi Viksar, I have also faced the same issue.. SQL Server agent will not be accessible untill all your database has recovered after recycle / reboot....
Separate names with a comma.
