Viewing 15 posts - 271 through 285 (of 560 total)
shahgols (6/5/2014)
We have dropped a huge table from one of our databases and I want to get some of that space back. However, the shrink of the...
June 6, 2014 at 8:32 am
john.p.lantz (6/5/2014)
I'm trying to get stats for a stored procedure that has already executed. ...
June 5, 2014 at 8:53 pm
matak (6/3/2014)
select distinct
itemno as [Item],
count(*) over (partition by ITEMNO) as [Purchases],
sum(case when entrytype = 0 then qty else 0 end) over (partition by ITEMNO) as [QtyPurchased],
sum(case...
June 4, 2014 at 12:08 pm
Mauricio N (6/3/2014)
thanks for your answer. This is just for a QA environment and it won't run in Live. What I'm trying to do is just save...
June 3, 2014 at 10:50 am
Mauricio N (6/3/2014)
I want to save every query executed from a given software, let's say Multi Script for example, and save in a table query...
June 3, 2014 at 9:53 am
After some thought and running a trace , I fixed it this way.
I created a temporary table for RecipeMap, the biggest table. Run a simple select statement against that table...
June 3, 2014 at 5:31 am
GilaMonster (5/27/2014)
sql-lover (5/26/2014)
SQL Server does not hold statistics for table variables so row count is always 1.
Not actually true.
A good rule of thumb is picking table variables for small sets,...
May 27, 2014 at 5:40 am
TheSQLGuru (5/24/2014)
May 26, 2014 at 9:27 pm
TheSQLGuru (5/26/2014)
May 26, 2014 at 9:12 pm
ramana3327 (5/26/2014)
Hi,You mentioned stats here. How do we know how often we have to update stats. How to find the optimizer is using right stats or not?
SQL Server does not...
May 26, 2014 at 5:12 pm
ramana3327 (5/24/2014)
Thanks Everyone.Please let me know,
How the table spool effect the performance? In what situation we can get table spool in execution plan and how can we avoid that?
This...
May 24, 2014 at 5:42 pm
I experienced this same issue a week ago. No ballooning, VMware was fine. The problem was an IO Fusion profiler that was sucking memory from the SQL server. PLE dropped...
May 23, 2014 at 11:24 am
muthyala_51 (5/19/2014)
May 23, 2014 at 8:49 am
pgmoschetti (5/23/2014)
TheSQLGuru (5/23/2014)
.... assuming you don't make the secondary readable, which can do nasty things, including to your primary database ....
Unfortunately operators have the option to query the...
May 23, 2014 at 8:29 am
Lempster (5/23/2014)
sql-lover (5/23/2014)
I don't know if deprecated is the right word. It is set to be removed on future releases.
That's what 'deprecated' means!! I didn't say that mirroring is...
May 23, 2014 at 8:21 am
Viewing 15 posts - 271 through 285 (of 560 total)