Viewing 15 posts - 2,731 through 2,745 (of 8,761 total)
We have an issue whereby over-complex filters within queries generated by a report engine are resulting in wildly overestimated cardinality estimates.
I see this often and capping the memory grants...
November 14, 2016 at 10:11 am
drew.allen (11/14/2016)
Isn't this essentially the same question that you had in Recursive CTE performance improvement. You received an answer to this question there.Drew
Just wonder if the OP didn't understand...
November 14, 2016 at 10:02 am
Luis Cazares (11/14/2016)
Eirikur Eiriksson (11/14/2016)
😎
If the plan contains sensitive data then you can use SQL Sentry Plan Explorer...
November 14, 2016 at 9:57 am
Can you post the actual execution plan, would make this a lot easier.
😎
If the plan contains sensitive data then you can use SQL Sentry Plan Explorer to anonymize it before...
November 14, 2016 at 9:46 am
Here is another option, no need to concatenate the key columns
😎
INSERT INTO [addb20].[Target_MergeAMD4_WithData].[dbo].[ConfigOption]
(
[Active]
, [ConfigOptionGUID]
, [ConfigOptionTypePropertyId]
...
November 14, 2016 at 9:42 am
gisles (11/14/2016)
Yes, this is in all of them.
Manipulating the CF files in T-SQL is not trivial, the internal format is a FAT format which can be slightly twisted to work...
November 14, 2016 at 7:03 am
Brandie Tarvin (11/14/2016)
I don't know if I'm having a language barrier issue with this vendor rep or if this person is truly this clueless.
VendorRep: Make sure to restore this copy...
November 14, 2016 at 6:51 am
raymak (11/14/2016)
Thank you. 🙂
You are very welcome.
😎
November 14, 2016 at 6:48 am
adb2303 (11/14/2016)
Thanks for the response.
SQL Server version
Microsoft SQL Server 2008 R2 (SP3) - 10.50.6220.0 (X64) Mar 19 2015 12:32:14 Copyright (c) Microsoft Corporation Enterprise Edition...
November 14, 2016 at 6:45 am
adb2303 (11/11/2016)
I have just upped the cost threshold for parallelism to 50 on two of our test servers:
SP_CONFIGURE 'advanced', 1
GO
RECONFIGURE WITH OVERRIDE
GO
SP_CONFIGURE 'cost threshold for parallelism',50
GO
RECONFIGURE WITH OVERRIDE
GO
SP_CONFIGURE
This took 4m33s...
November 14, 2016 at 5:59 am
Jose Marcelo Dias de Oliveira (11/14/2016)
Eirikur Eiriksson (11/12/2016)
Jose Marcelo Dias de Oliveira (11/10/2016)
I have the same behavior in 2 SQL Servers where Stolen Server Memory and Database Cache Memory counters...
November 14, 2016 at 5:31 am
124420294 (11/14/2016)
sql server 2016.if sql 2005 support transaction log roll forward, I think, it should be also supported for 2016.
A VSS file backup is not the same as an...
November 14, 2016 at 5:08 am
hurricaneDBA (11/14/2016)
I hope you're all doing great
We've implemented SP 2013 using SQL server 2012 with file streaming enabled and RBS.
Now we have over 35 databases with...
November 14, 2016 at 4:55 am
IT researcher (11/14/2016)
As i said earlier "In the license terms under the ‘Scope of License’ there mentioned “You may not publish the software for others to copy”."
Which is not...
November 14, 2016 at 4:49 am
Another thing to pay attention to is the cost of using COUNT, it implies that the whole table must be scanned and aggregated, much heavier on the database than using...
November 14, 2016 at 4:44 am
Viewing 15 posts - 2,731 through 2,745 (of 8,761 total)