Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,061 through 18,075 (of 59,069 total)

RE: Dimension Date format

PB_BI (3/18/2016)
When I get in front of a SQL instance I'll try to resolve it, unless you have any thoughts?
Yes. Don't use the WK datepart of SQL Server, ever!...
--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)

March 18, 2016 at 7:47 am

#1866136
RE: Building Better Software

In a similar vein... it's not possible for some companies to build better software because of the apparent incredible lack of even basic talent out there. Heh... can 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)

March 17, 2016 at 10:17 pm

#1866053
RE: Typing Spelling error check

SQLPain (3/17/2016)
user does not have a option for selection, they can only type it in.
There should be some form of validation on the front end to prevent this type of...
--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)

March 17, 2016 at 9:46 pm

#1866052
RE: Sudden performance hit

PretendDBA (3/17/2016)
Wow, in a modern SAN that is a significant performance hit from 1 failed disk.
Worse than that, there was a bad disk that slowed the system down to 1/3rd...
--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)

March 17, 2016 at 9:35 pm

#1866051
RE: Dimension Date format

PB_BI (3/9/2016)
tonzonline (3/5/2016)
Hi,
Is the problem because I create this dimension by Wizard and choose "Create Time table from server" ?
I also notice, NameColumn property is "New binding(WChar)
If I click 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)

March 17, 2016 at 9:07 pm

#1866049
RE: sp_rename of default constraint

N_Muller (3/17/2016)
I have a table MyTable and in it I have a column with default constraint named DF_MyTable_MyColumn
I renamed the table to MyTable_XYZ by:
sp_rename 'MyTable', 'MyTable_XYZ'
That worked great. Next...
--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)

March 17, 2016 at 5:49 pm

#1866039
RE: Change t-sql 2012 to not use a cte

Hopefully, it's one of those really, really hard rubber bats with a steel core. 😀
--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)

March 17, 2016 at 5:28 pm

#1866037
RE: Dealing with large tables (Financial transactions)

TheSQLGuru (3/17/2016)
But generally is it better to have data files on a slower drive and log files on SSD (I assume it depends)? Might be worth mentioning that there is...
--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)

March 17, 2016 at 5:12 pm

#1866035
RE: Find hierarchyID from different parts of a node?

yb751 (3/17/2016)
Sigh, so close!
Tested, Jeff's technique and it works great. Had to make some modifications to the code to work with my data but it wasn't too bad. ...
--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)

March 17, 2016 at 2:46 pm

#1866011
RE: Find hierarchyID from different parts of a node?

yb751 (3/17/2016)
Ok, Jeff...you're starting to make a believer out of me. Hierarchyid's are all nice and dandy until you go ahead and move a node. Sure there is...
--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)

March 17, 2016 at 2:43 pm

#1866010
RE: Find a String in a String

quagmired (3/17/2016)
My personal favorite is, given the same accuracy, which ever is the fastest and least resource intensive. That's usually not REGEX as called from SQL SERVER even when...
--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)

March 17, 2016 at 2:38 pm

#1866006
RE: Dealing with large tables (Financial transactions)

DesNorton (3/15/2016)
Emil B (3/14/2016)
... the table has about 90mlns of rows with 20 GB data space and 26 GB index space ...
The cleverer peepels here will probably shoot me down...
--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)

March 17, 2016 at 8:11 am

#1865862
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (3/17/2016)
mister.magoo (3/16/2016)
I can only really get on board with the Empty Set, as both the other options, if COUNTed would tell me the string had split into 1 (one)...
--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)

March 17, 2016 at 8:03 am

#1865861
RE: Index rebuild completion on a partitioned table

Apologies for the observation but with all the alphabet soup after your name, you don't know?
--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)

March 16, 2016 at 9:58 pm

#1865793
RE: Case sensitive with ROLLUP

I have to ask... why do they want to differentiate between a proper case spelling and a low case spelling of the same word? Heh... please tell me...
--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)

March 16, 2016 at 9:54 pm

#1865792

Viewing 15 posts - 18,061 through 18,075 (of 59,069 total)