Viewing 15 posts - 6,556 through 6,570 (of 49,552 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,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2015 at 4:27 am
Before answering your last three questions...
Why are you considering running it at all?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2015 at 1:37 am
TheSQLGuru (2/12/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 12, 2015 at 5:31 am
Zohaib Anwar (2/12/2015)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 12, 2015 at 5:30 am
You want to shrink the file without shrinking the file?
Why is 5GB too big?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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."
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
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)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 12, 2015 at 4:12 am
Viewing 15 posts - 6,556 through 6,570 (of 49,552 total)