Reputation
1,570
Top tag
Next privilege 2,000 Rep.
Edit questions and answers
Badges
11 28
Impact
~119k people reached

Mar
17
revised TSQL Script Execution Through Power shell, Special Characters Rendering Problem
added 80 characters in body
Mar
17
revised TSQL Script Execution Through Power shell, Special Characters Rendering Problem
added 55 characters in body
Mar
15
asked TSQL Script Execution Through Power shell, Special Characters Rendering Problem
Mar
1
comment TempDB contentions
Recently have we found that, TempDB is still under pressure and its happening because we are using "Contains Table" and SQL Server is creating a Hash Join on every execution. Basically its bug in SQL Server 2014. Fixed by using latest CU and issue is resolved. support.microsoft.com/en-us/kb/2999809
Feb
26
awarded  Notable Question
Feb
17
awarded  Benefactor
Feb
16
awarded  Nice Question
Feb
16
accepted TempDB contentions
Feb
16
comment TempDB contentions
Thanks a lot, your detail answer pushed us to search more in detail. How did we missed it before "Autogrow of file 'templog' in database 'tempdb' was cancelled by user or timed out after 7704 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size." This we found in log when ever this type of problem is occurring. We are moving TempDB to separate fast drive.
Feb
15
awarded  Promoter
Feb
13
asked TempDB contentions
Jan
24
awarded  Enlightened
Jan
24
awarded  Nice Answer
Sep
2
awarded  Popular Question
Aug
5
awarded  Popular Question
Aug
4
awarded  Constituent
Jul
31
awarded  Caucus
Jul
17
awarded  Yearling
Jun
22
awarded  Quorum
Jun
2
reviewed No Action Needed Access mysql database from another system using LAN (Wired or Wireless)