Viewing 15 posts - 286 through 300 (of 1,129 total)
Jack Corbett (3/4/2014)
DECLARE @data NVARCHAR(MAX) =...
March 4, 2014 at 12:17 pm
Jack Corbett (3/4/2014)
My best guess is...
March 4, 2014 at 11:37 am
Jack Corbett (3/4/2014)
DECLARE @data NVARCHAR(MAX) = 'EXEC Proc_gen @PsID=12, @kID=-1, @ID=3183';
SELECT @data AS theData...
March 4, 2014 at 9:13 am
sqlbuddy123 (2/28/2014)
Yes ..--
SQLBuddy
If query cost is less than CTP it will always use only 1 processor?
February 28, 2014 at 1:23 pm
sqlbuddy123 (2/28/2014)
curious_sqldba (2/28/2014)
February 28, 2014 at 1:18 pm
ChrisM@home (2/6/2014)
curious_sqldba (2/6/2014)
ChrisM@home (2/6/2014)
curious_sqldba (2/6/2014)
ChrisM@home (2/6/2014)
Dropping index 1 and creating Index 2.
Why would you choose index 2 over index1?
I am not, i just...
February 6, 2014 at 1:43 pm
ChrisM@home (2/6/2014)
curious_sqldba (2/6/2014)
ChrisM@home (2/6/2014)
Dropping index 1 and creating Index 2.
Why would you choose index 2 over index1?
I am not, i just asked a...
February 6, 2014 at 1:24 pm
ChrisM@home (2/6/2014)
Dropping index 1 and creating Index 2.
Why would you choose index 2 over index1?
I am not, i just asked a question ...
February 6, 2014 at 1:16 pm
clayman (11/21/2013)
Hi,If you have used powershell before, look at http://gallery.technet.microsoft.com/scriptcenter/9d0070f5-98d3-4c82-9b20-555c49f6537d
I just want to script out given jobs, basically i am thinking of having a config file which will have...
November 22, 2013 at 11:29 am
GilaMonster (11/12/2013)
Nope. Not unless your bulk load is querying the table first. Stats do not get created or updated unless they are needed to generate an execution plan.
So bulk inserts...
November 12, 2013 at 9:06 am
GilaMonster (11/11/2013)
Don't, it'll have no effect on performance. Stats aren't created or updated until needed.Do an update with fullscan afterwards, but no need to disable any options.
My understanding is if...
November 12, 2013 at 8:37 am
Keith Tate (11/6/2013)
November 7, 2013 at 7:56 am
RVO (11/4/2013)
with parameter 'VEH' and 'COM'
and in both cases it is this step that is taking up all the resources:
Index Scan (NonClustered)
[prj_detail].[IXN_prj_detail__per_end_date__detail_type_ind__evc_code__evc_type_code]
Cost: 91%
Another pattern I noticed is...
November 4, 2013 at 2:15 pm
RVO (11/4/2013)
"...Have you looked at indices and stats before changing the code?..."
No I have not done this.
I am not a big guru when it comes to TSQL performance tuning.
Can...
November 4, 2013 at 9:25 am
RVO (11/4/2013)
I think parameter sniffing is definitely might be the root cause.
I am rewriting procedure now to use local variables.
Will let you know...
November 4, 2013 at 9:02 am
Viewing 15 posts - 286 through 300 (of 1,129 total)