Viewing 15 posts - 286 through 300 (of 430 total)
Brandie Tarvin (7/29/2011)
It wasn't the SQL Login's problem at all. The website uses a domain account to access SQL Server and that domain account didn't have...
July 29, 2011 at 5:31 am
Keep an eye on TempDB too when you run this intense command on a big database.
July 29, 2011 at 2:35 am
Brandie Tarvin (7/28/2011)
The SQL Login has db_datareader on all the appropriate databases. Proc was created in DB1 (under schema dbo) and pulls from tables in DB2.
GRANT...
July 29, 2011 at 1:52 am
Megistal (7/28/2011)
Were you able successful in getting past that error from the command prompt? Had the same on R2(Yeah the post is 2 years old...)
What actually are you trying to...
July 28, 2011 at 7:47 am
forsqlserver (7/28/2011)
Can I kill any one of deadlocked process?
Killing a process sometimes is a sin. 4 Years back when I was just into SQL dba work, I found that...
July 28, 2011 at 7:34 am
Gregory Brown (7/28/2011)
I just installed the latest Denali on a test machine to take a look.How do I get the T-SQL to continuously monitor on a specified interval?
May be using...
July 28, 2011 at 6:10 am
Gregory Brown (7/28/2011)
July 28, 2011 at 6:05 am
forsqlserver (7/28/2011)
2008 R2Are u sure Backup compression is not used in 2008?
As you stated that you are on 2008 R2, you can try compressing the backup and see how much...
July 28, 2011 at 6:01 am
Ignacio A. Salom Rangel (7/28/2011)
chandan_jha18 (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
chandan_jha18 (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
July 28, 2011 at 5:59 am
Raghavender (7/25/2011)
I am new to query tuning.
Can you please let know the process, steps which needs to take if any body comes to us and asks, that they have...
July 28, 2011 at 4:17 am
Ignacio A. Salom Rangel (7/28/2011)
chandan_jha18 (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
July 28, 2011 at 4:15 am
brown-415622 (7/28/2011)
model database is stuck in a restore state. Any...
July 28, 2011 at 3:57 am
Ignacio A. Salom Rangel (7/28/2011)
Mike's tip is very good. In case you don't have SQL 2008 Enterprise of SQL 2008 R2, you can still compress the backup.
In 2008 R2, even...
July 28, 2011 at 3:55 am
jpmathew10 (7/28/2011)
The job scheduled daily @ 3:00AM.And it took below 10 mins to complete.But the job executed daily @ different times
Like 9:45AM,8:57AM,9:05AM,10:30AM,9:33AM etc
then surely there is something else causing...
July 28, 2011 at 3:53 am
Gregory Brown (7/27/2011)
July 28, 2011 at 2:38 am
Viewing 15 posts - 286 through 300 (of 430 total)