Jeff Moden

Forum Replies Created

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

RE: OPENROWSET - issue with spaces in the file name

mr-967650 - Sunday, November 4, 2018 1:04 PM
Jeff Moden - Sunday, November 4, 2018 11:45 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)

November 4, 2018 at 3:59 pm

#2012349
RE: OPENROWSET - issue with spaces in the file name

I've not been able to make it fail with the following code, which I've just tested on my box.

SELECT *
FROM OPENROWSET
(
--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 11:45 am

#2012344
RE: Explaining Our Professions to Our Parents

stan.kappiris - Saturday, November 3, 2018 6:35 PM
Iâ€™ve been playing with computers a long time. But when somebody asks me what 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)

November 4, 2018 at 10:51 am

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

JSB_89 - Sunday, November 4, 2018 8:32 AM
Thanx Jeff will check with the SAN team, but going back to my original question...
--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 9:13 am

#2012342
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

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