Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,866 through 11,880 (of 59,064 total)

RE: Who Likes NULL?

Dennis Q Miller - Monday, July 9, 2018 2:23 PM
edwardwill - Monday, July 9, 2018 6:34 AM

July 9, 2018 at 2:46 pm

#1996868
RE: Importing Tricky CSV Files with PowerShell

HighPlainsDBA - Monday, July 9, 2018 2:10 PM
Jeff Moden - Monday, July 9, 2018 11:56 AM

July 9, 2018 at 2:36 pm

#1996867
RE: Importing Tricky CSV Files with PowerShell

HighPlainsDBA - Monday, July 9, 2018 11:42 AM
Thanks for sharing this. Reminded me how much I hate comma delimited files, arguably the...

July 9, 2018 at 11:56 am

#1996842
RE: CmdExec to delete files not working

Samwell - Monday, July 9, 2018 5:50 AM
It's running as a SQL Agent job and the service account running SQL Agent has...

July 9, 2018 at 11:36 am

#1996839
RE: Accurate Estimations, But Hash Match Aggregate Spilling to TempDB

chris.o.smith - Friday, June 29, 2018 10:10 AM
Hi,
I'm on SQL Server 2016 Enterprise, V13.0.5026.0. I have a straightforward query that runs on...

July 9, 2018 at 11:26 am

#1996834
RE: Prevent update trigger

Nqobilemoyo - Monday, July 9, 2018 10:12 AM
I have a database and i would like to create a trigger which will not...

July 9, 2018 at 11:22 am

#1996832
RE: The GDPR is Coming to the US

Brent Ozar - Monday, July 9, 2018 11:01 AM
Thankfully California was so much smarter with their qualifications than the EU was -...

July 9, 2018 at 11:21 am

#1996831
RE: Measure Calculation

RonKyle - Monday, July 9, 2018 9:52 AM
If that field is subject to modification, that might be a real problem.
If that...

July 9, 2018 at 10:50 am

#1996826
RE: Measure Calculation

RonKyle - Monday, July 9, 2018 9:17 AM
Make sure you cluster on whatever field is aggregated. Otherwise the engine will have to...

July 9, 2018 at 9:24 am

#1996807
RE: Who Likes NULL?

edwardwill - Monday, July 9, 2018 6:58 AM
Chris Harshman - Monday, July 9, 2018 6:52 AM

July 9, 2018 at 8:42 am

#1996795
RE: STRING_SPLIT()

Raghavender Chavva - Monday, July 9, 2018 8:26 AM
When I executed this code in SQL Server 2016, below is the error:
Procedure expects...

July 9, 2018 at 8:38 am

#1996794
RE: execute strored procedure through OPENROWSET-SYNTAX ERROR

george.sofroniadis - Monday, July 9, 2018 7:12 AM
declare @tmp as varchar(25)
set @tmp ='Î Î‘Î Î‘Î“ÎŸÎ¥'
SELECT
*
INTO
#tmpSortedBooks
FROM
OPENROWSET(
'SQLNCLI',
'Server=MNG01\MPISDARIS;Trusted_Connection=yes;Database=Reporting;',
'EXEC...

July 9, 2018 at 7:55 am

#1996785
RE: Dealing with Disparate Goals

My experience has been that it all comes down to proper bi-directional communications. By "proper", I mean that management drops the "I'm the boss... do it my way" attitude and...

July 9, 2018 at 6:39 am

#1996771
RE: Importing Tricky CSV Files with PowerShell

Stewart "Arturius" Campbell - Sunday, July 8, 2018 11:34 PM
been away (out of mobile range) for a few days. This has been...

July 9, 2018 at 6:30 am

#1996768
RE: Who Likes NULL?

Sean Redmond - Monday, July 9, 2018 1:07 AM
chrisbray - Monday, July 9, 2018 12:48 AM

July 9, 2018 at 6:29 am

#1996767

Viewing 15 posts - 11,866 through 11,880 (of 59,064 total)