Viewing 15 posts - 3,106 through 3,120 (of 8,753 total)
Any upgrades available for the Crystal Ball?
😎
October 5, 2016 at 2:56 am
ramyours2003 (10/4/2016)
I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for performance....
October 5, 2016 at 2:43 am
drew.allen (10/3/2016)
October 3, 2016 at 9:33 am
DesNorton (10/3/2016)
Thanks for this Eirikur. It's always good to find ways of improving performance.
What I would like to understand, is
1 - what makes Method#2 perform better than Method#1, and...
October 3, 2016 at 9:09 am
Luis Cazares (10/3/2016)
Jeff Moden (10/2/2016)
The Dixie Flatline (9/30/2016)
Fortunately, I only need around 300, not thousands. 😀Thanks guys.
Just curious.... what are you doing that needs so...
October 3, 2016 at 7:53 am
NineIron (10/3/2016)
October 3, 2016 at 5:02 am
watto84 (10/2/2016)
That is incredible. I really appreciate your help, you have done an outstanding job with it, as a newbie there was no way I could have worked that out.
You...
October 2, 2016 at 11:54 pm
Quick example, should be enough to get you started.
😎
USE TEEST;
GO
SET NOCOUNT ON;
IF OBJECT_ID(N'dbo.stat') IS NOT NULL DROP TABLE dbo.stat;
create table dbo.stat
(
gameID int
...
October 2, 2016 at 11:00 pm
You are very welcome.
😎
Note that there must be entries in the set that cover the full range, otherwise the query will not return anything when querying for missing ranges.
October 2, 2016 at 10:09 pm
Can you please post the DDL (create table) script for the relevant tables, sample data as insert statements and the expected results?
😎
Further, can you also post the full output...
October 2, 2016 at 10:06 pm
BLOB_EATER (10/2/2016)
Into my 19th hour for the weekend shift decided to google (Gone off bing) well know SQL Server people and found this (attached).... Im scared.
Don't be scared of him,...
October 2, 2016 at 10:19 am
chris.asaipillai-624309 (10/2/2016)
OK if I need to extract another item from that pice of xml then do I write this folowing
SELECT
SX.OldRow.value('(Airline/@lastUpdatedByUserID)[1]','INT') AS lastUpdatedByUserID,
...
October 2, 2016 at 4:44 am
komal145 (9/30/2016)
date Sends Opens ...
October 2, 2016 at 2:26 am
Quick thought, I wouldn't expect the optimizer to do anything but abort the optimizing process on a time out when handling queries with hundreds of apply operators.
😎
October 2, 2016 at 2:21 am
Several ways of doing this, here is one fairly straight forward method
😎
Note: added few entries to the sample data.
USE TEEST;
GO
SET NOCOUNT ON;
--- Query parameters
DECLARE @ITEM ...
October 2, 2016 at 1:58 am
Viewing 15 posts - 3,106 through 3,120 (of 8,753 total)