Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,171 through 16,185 (of 59,067 total)

RE: OpenRowset for CSV File

joshua 15769 (12/1/2016)
Currently I'm looking at solutions on how to fix the error when the CSV file and our database are not equal in terms of column count. But I...
--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 1, 2016 at 6:34 pm

#1915608
RE: Best and economical enterprise monitoring tool

Eric M Russell (12/1/2016)
Jeff Moden (12/1/2016)
Benki Chendu (11/29/2016)
Friends,
I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using...
--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 1, 2016 at 6:28 pm

#1915607
RE: A scenario where SQL Server doesn't seem to help

It would appear that the OP has left the building.
--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 1, 2016 at 6:14 pm

#1915606
RE: Execute a Powershell script from inside a stored procedure?

Gail Wanabee (12/1/2016)
Jeff, I agree, I just didn't know you could do that. I'm not a Windows Server administrator.
On a complete server reboot, can you recommend a way to have...
--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 1, 2016 at 6:12 pm

#1915605
RE: Functions Database

Chris Harshman (12/1/2016)
I like to use synonyms for cross-database interaction instead of a 3 part name because our nomenclature has the environment name as a suffix of the db name...
--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 1, 2016 at 4:47 pm

#1915598
RE: OpenRowset for CSV File

joshua 15769 (12/1/2016)
Hi Sir Jeff Moden,
Good Day.
Sir, If you dont mid asnwering again, I searched in the internet but to no avail. My current problem is, the data which I...
--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 1, 2016 at 4:41 pm

#1915597
RE: Best and economical enterprise monitoring tool

Benki Chendu (11/29/2016)
Friends,
I have used Microsoft SCOM, HP Openview, BMC Patrol and a few more tools to monitor my database infrastructure..But currently, I am using a tool called traverse for...
--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 1, 2016 at 3:32 pm

#1915594
RE: Best way to automate running adhoc scripts?

I wouldn't make another move without talking with the Developers and finding out what and why there is a need for so many data changes to prod and let them...
--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 1, 2016 at 3:29 pm

#1915593
RE: Execute a Powershell script from inside a stored procedure?

Gail Wanabee (12/1/2016)
Grant, this needs to implemented in a startup stored procedure in the master database, before SQL Server has actually started.
What I plan to do is to create...
--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 1, 2016 at 3:13 pm

#1915591
RE: Execute a Powershell script from inside a stored procedure?

Grant Fritchey (12/1/2016)
It's going to be more than a little sloppy.
Not sure why anyone would say such a thing. What kind of "slop" are you taking about?
--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 1, 2016 at 3:11 pm

#1915590
RE: RAMDisk? Use it for TempDB?

Gail Wanabee (12/1/2016)
Jeff, we've looked as deeply as we can into what is a completely black box implementation.
Ah... got it. Gotta "love" hyper-convergence appliances. Thanks for the feedback.
Considering...
--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 1, 2016 at 2:31 pm

#1915582
RE: TempDb File Sizing

There's no way in hell that I'd enable TF 1117. It doesn't just affect TempDB and I don't want the nearly 90 temporal files/filegroups for a 600GB table 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 1, 2016 at 8:30 am

#1915434
RE: RAMDisk? Use it for TempDB?

If it has a problem with disk writes, then TempDB is probably the least of your worries. Have you looked into what that system is doing to log file...
--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)

November 30, 2016 at 10:21 pm

#1915321
RE: Finally, Create or Alter

hakim.ali (11/30/2016)
Jeff Moden (11/29/2016)
Treating a table like code makes no sense.
Why? I ask not as a challenge, but to understand your reasoning. I have generally leaned towards treating tables as...
--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)

November 30, 2016 at 4:27 pm

#1915302
RE: Mathematics/Algorithms in SQL

OR... are you looking for things like why you might want to use Integer math, how to do things with dates and times, how to compare two differently partitioned ROW_NUMBER()...
--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)

November 30, 2016 at 4:03 pm

#1915298

Viewing 15 posts - 16,171 through 16,185 (of 59,067 total)