Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,261 through 10,275 (of 59,099 total)

RE: WMI connection error using Invoke-Sqlcmd

Heh... ok. Understood. But, if your stuff is working, you should be teaching PowerShell users a new skill. 😀
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 22, 2018 at 10:49 am

#2017162
RE: PERCENTILE_DISC for median calculation

drew.allen - Wednesday, December 19, 2018 1:48 PM
Jeff Moden - Tuesday, December 18, 2018 8:20 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 6:53 pm

#2017149
RE: WMI connection error using Invoke-Sqlcmd

smw147 - Wednesday, December 19, 2018 3:12 AM
... am trying to convert an old batch script that run some sql files via sqlcmd command to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 6:34 pm

#2017147
RE: Best Practice for batch processing In SQL Server

Preprocess all your data in staging tables. When you're ready to update the final tables from the staging tables, start with ...
SET XACT_ABORT ON;
BEGIN TRANSACTION
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 6:32 pm

#2017146
RE: Month T-1

1. Hopefully this teaches why you should never store formatted dates in a table. Leave such formatting to when you need to present the data.
2. Hopefully this also teaches...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 6:24 pm

#2017145
RE: Convert string MMDDYYYY to a date

Jeffrey Williams 3188 - Friday, December 21, 2018 10:36 AM
below86 - Thursday, December 20, 2018 2:47 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 2:06 pm

#2017139
RE: Performance Counters

edwardwill - Friday, December 21, 2018 3:28 AM
Could you provide a link to an authoritative resource, please?
This is one of those "If...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 9:22 am

#2017094
RE: dealing with Bulk load data conversion error

I do use the error sequestration functionality of BULK INSERT but I hate the cryptic messages it stores. I've never understood why the messages can't be more like the ones...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 9:19 am

#2017093
RE: Convert string MMDDYYYY to a date

frederico_fonseca - Friday, December 21, 2018 8:25 AM
timings is going to depend hugely on the spec.
on my laptop (I7-8550-U 1.8GHz - 16...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 8:43 am

#2017079
RE: Using Hash values as Dimension Keys in Datawarehouse

xsevensinzx - Friday, December 21, 2018 7:16 AM
Jeff Moden - Thursday, December 20, 2018 8:59 AM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 8:11 am

#2017074
RE: Convert string MMDDYYYY to a date

Eirikur Eiriksson - Friday, December 21, 2018 2:29 AM
Jeff Moden - Thursday, December 20, 2018 10:36 PM
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 21, 2018 at 7:53 am

#2017072
RE: Rebuild index taking time

rinu philip - Thursday, December 20, 2018 6:20 PM
Question: rebuild index task in a SQL 2014 ENV is taking a long time...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 20, 2018 at 10:49 pm

#2017014
RE: Rebuild index taking time

pietlinden - Thursday, December 20, 2018 8:33 PM
This might be a helpful read:
https://www.brentozar.com/archive/2013/09/index-maintenance-sql-server-rebuild-reorganize/
Lordy, don't use REORGANIZE. It'll take longer, beat the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 20, 2018 at 10:46 pm

#2017013
RE: Convert string MMDDYYYY to a date

Since you're using SQL Server 2012, DATEFROMPARTS with substrings to isolate the parts might be the fastest.
Of course my initial thought is to ask that they send...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 20, 2018 at 10:36 pm

#2017012
RE: urgent

Welcome. I suggest that you first download a free copy of SQL Server 2016 or 2017 Developers Edition, install it on your computer, buy a book on the subject and...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

December 20, 2018 at 10:30 pm

#2017011

Viewing 15 posts - 10,261 through 10,275 (of 59,099 total)