Viewing 15 posts - 6,556 through 6,570 (of 49,571 total)
A global temp table is dropped as soon as the connection which created it closes and no one else is referencing it. Hence when step 1 of the job finished,...
February 13, 2015 at 4:29 am
No.
If there's been no full backup of the primary since you can use a differential to bridge the gap (take diff backup on primary, restore with no recovery on secondary)....
February 13, 2015 at 4:27 am
Before answering your last three questions...
Why are you considering running it at all?
February 13, 2015 at 1:38 am
Smells like a parameter sniffing problem.
No, WITH RECOMPILE is not the solution. It may 'fix' things, but it's a sledgehammer and it'll send your CPU usage way, way up.
Can't say...
February 13, 2015 at 1:37 am
TheSQLGuru (2/12/2015)
February 13, 2015 at 1:29 am
Not possible. Suggest to them that they encrypt, in the application, any data that they don't want the DBA to see.
February 12, 2015 at 8:43 am
All nonclustered indexes contain the clustered index key.
Hence, that nonclustered index on Name contains both Name and ContactTypeId
Your query has no where clause, hence there's no possibility for anything other...
February 12, 2015 at 7:49 am
Then motivate to get someone in to help out in this area. Most good consultants will teach as they fix, so you get the immediate problems fixed and you learn...
February 12, 2015 at 6:31 am
Zohaib Anwar (2/12/2015)
Ok can you please suggest that can we use WAITFOR (Transact-SQL) in this SP for timeout?
Lol. You have a problem where the procedure is taking...
February 12, 2015 at 6:03 am
cathrinegarcia24 (2/12/2015)
1. MICROSOFT TECHNOLOGY ASSOCIATE (MTA)
That's for people with no experience, it's not required by the MCSA/MCSE and is probably a waste of time for anyone who's got DBA/DB Dev...
February 12, 2015 at 5:44 am
twin.devil (2/12/2015)
if you do not want to change that then you should begin and commit against each INSERT you are performing in your query.
I strongly disagree there.
Doing as you suggest...
February 12, 2015 at 5:31 am
Zohaib Anwar (2/12/2015)
February 12, 2015 at 5:30 am
You want to shrink the file without shrinking the file?
Why is 5GB too big?
February 12, 2015 at 4:15 am
Start by figuring out why it's growing. Search for my article "Help, my transaction log is full."
February 12, 2015 at 4:14 am
There isn't one.
MCSA: SQL Server 2012
MCSE (This one's been updated with some 2014 stuff)
February 12, 2015 at 4:12 am
Viewing 15 posts - 6,556 through 6,570 (of 49,571 total)