Viewing 15 posts - 11,701 through 11,715 (of 49,552 total)
born2achieve (9/14/2013)
1. using Not In
2. Using Left Join
3.Using Not Exists.
Which one is the best choice to achieve this...
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
September 14, 2013 at 8:06 am
Those two queries are completely different, and the first has a syntax error to boot.
First the syntax error
select * from label
where label.uniqueCode not in (select uniqueCode from...
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
September 14, 2013 at 12:29 am
Maybe possible, maybe not.
You'll need to hack the database back into the server (google for hack attach Paul Randal)
Then, if that's successful, you'll need to see if you can take...
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
September 13, 2013 at 6:44 pm
You need to figure out what is causing Windows to issue low memory alerts. SQL will not reduce its memory usage unless Windows tells it to.
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
September 13, 2013 at 3:47 pm
The answer to that was to take a tail-log backup before you restored over the damaged database....
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
September 13, 2013 at 3:41 pm
There's minimal awareness of the MCSM in industry as it is (which is what you'll get if you pass the 2012 exams, not the older MCM), that awareness is not...
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
September 13, 2013 at 10:41 am
You're looking for something other than SQL allocating memory, probably lots of memory. The memory-based counters and/or the process object and its memory counters for each and every process running.
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
September 13, 2013 at 10:31 am
ekant_alone (9/13/2013)
My assumption was that SP has sequential processing and not parallel processing. Is it possible that it can run statement 2 along with step 1.
Your assumption is correct,...
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
September 13, 2013 at 10:28 am
TheSQLGuru (9/13/2013)
4) The WITH (ROWLOCK) hint could be helpful. See Books Online for info.
Or could make it worse. 15000 rows locked at the row level is above the threshold...
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
September 13, 2013 at 10:26 am
To be honest, if you're planning to write it I'd say don't bother. You're looking at $3000, assuming passing both the first time (which many people don't), 3 months is...
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
September 13, 2013 at 10:23 am
They wouldn't have reduced memory usage without a lowmem signal from windows, so if SQL is reducing memory usage, there's something outside of SQL allocating and requesting memory and causing...
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
September 13, 2013 at 10:20 am
No.
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
September 13, 2013 at 7:02 am
The snapshot isolations aren't the only things that use versioning. Off the top of my head online index rebuilds use versioning and triggers use the row version store. I know...
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
September 13, 2013 at 5:19 am
Sean Pearce (9/13/2013)
I am seeing version ghost records in one of my databases but the database has Snapshot Isolation switched off. Is this possible?
Yes. 😀
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
September 13, 2013 at 5:06 am
gary1 (9/12/2013)
In which scenarios, sql server instance will release it's memory other than it's service restarts?
When windows is under memory pressure and requests SQL to reduce its memory usage.
Do we...
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
September 13, 2013 at 5:03 am
Viewing 15 posts - 11,701 through 11,715 (of 49,552 total)