Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,726 through 10,740 (of 59,095 total)

RE: DT_BYTE to DT_DBDATE

If it appears as a single string, then the following will do the trick for you, depending on your need..

--===== This is just simplified test...
--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 4, 2018 at 8:20 am

#2012340
RE: DT_BYTE to DT_DBDATE

jklenk86 - Saturday, November 3, 2018 8:49 PM
So I did further digging. I have never seen this data type before. the MySQL...
--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 4, 2018 at 7:56 am

#2012339
RE: 4-4-5 Calendar Functions, Part 1

dkangel - Saturday, November 3, 2018 8:44 PM
Jeff Moden - Monday, September 28, 2009 8:05 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)

November 4, 2018 at 7:48 am

#2012337
RE: view generator

Flashx - Saturday, November 3, 2018 3:53 PM
Jeff Moden - Saturday, November 3, 2018 12:04 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)

November 4, 2018 at 7:40 am

#2012335
RE: TSQL query suddenly taking hours to run

p.s. You didn't make the mistake of shrinking your database files, did you?
--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 4, 2018 at 7:35 am

#2012334
RE: synonyms vs views when using a linked server

JSB_89 - Saturday, November 3, 2018 6:42 PM
Jeff Moden - Saturday, November 3, 2018 12:12 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)

November 4, 2018 at 7:21 am

#2012333
RE: TSQL query suddenly taking hours to run

Before you try anything, you said this problem started recently. The first thing you should do is make sure your statistics are up do date.
This is also an...
--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 3, 2018 at 12:22 pm

#2012314
RE: synonyms vs views when using a linked server

JSB_89 - Friday, November 2, 2018 4:24 PM
The company is driven by business so whatever the business needs we need 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)

November 3, 2018 at 12:12 pm

#2012313
RE: view generator

While I appreciate some of the technical aspects of the script, silently dropping existing views scares the heck out of me. I'd recommend adding a parameter that would default 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)

November 3, 2018 at 12:04 pm

#2012311
RE: huge free spaces in data file can make query slower?

Cool2018 - Saturday, November 3, 2018 10:22 AM
Jeff Moden - Friday, November 2, 2018 9:32 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)

November 3, 2018 at 11:41 am

#2012310
RE: huge free spaces in data file can make query slower?

Ah... Just noticed that you're using 2014. The VLF algorithm changed there. See the following article...
https://www.sqlskills.com/blogs/paul/important-change-vlf-creation-algorithm-sql-server-2014/
The bottom line, though, is that growing by percent is still...
--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 2, 2018 at 9:43 pm

#2012305
RE: huge free spaces in data file can make query slower?

I'm not sure why you have so much free space for the NDF files. Something is wrong there or you've measured something wrong or it's used space and not free...
--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 2, 2018 at 9:32 pm

#2012303
RE: huge free spaces in data file can make query slower?

Cool2018 - Friday, November 2, 2018 9:35 AM
Dear Jeff,
Thank you so much for all your advices and explanations.
Our current DB size...
--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 2, 2018 at 3:29 pm

#2012285
RE: Function Information

MMartin1 - Friday, November 2, 2018 12:25 PM
People have mentioned about formatting and casing consistency in code for readability. To me readability...
--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 2, 2018 at 3:16 pm

#2012284
RE: huge free spaces in data file can make query slower?

p.s. If your new requirement is to truncate the whole table and then reload it, it's almost stupid for the table to be partitioned. It's buying you very little and may...
--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 2, 2018 at 7:45 am

#2012186

Viewing 15 posts - 10,726 through 10,740 (of 59,095 total)