Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,631 through 15,645 (of 59,097 total)

RE: Trouble with openxml query

patrickmcginnis59 10839 - Thursday, February 16, 2017 11:52 AM
I'm curious that if SSN's ideally never make it onto computers, then why are...
--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)

February 16, 2017 at 4:17 pm

#1929002
RE: Training Computer Scientists

Grant Fritchey - Thursday, February 16, 2017 6:09 AM
Reading back through this set of comments is interesting. It does seem to boil...
--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)

February 16, 2017 at 8:09 am

#1928855
RE: CTE Recursive Query

The posted data won't load. It's missing quotes.
Msg 102, Level 15, State 1, Line 23
Incorrect syntax near '.1'.
Msg 102, Level 15, State 1, Line...
--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)

February 15, 2017 at 10:37 pm

#1928767
RE: Trouble with openxml query

pisorsisaac - Sunday, February 12, 2017 3:01 PM
Thanks much to those who helped me, I appreciate it.
To whoever it was that apparently...
--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)

February 15, 2017 at 10:07 pm

#1928764
RE: How to “step through” a list of values creating a record for each value

Why not just load the ACE drivers and read directly from the spreadsheet?
--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)

February 15, 2017 at 10:03 pm

#1928763
RE: Why dont i get the correct XML format while querying?

sgmunson - Wednesday, February 15, 2017 9:29 AM
Sorry, but that's not an option that I know of. You have the two...
--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)

February 15, 2017 at 9:52 pm

#1928761
RE: Training Computer Scientists

P Jones - Wednesday, July 1, 2015 1:12 AM
As an IT pro and graduate, I've been involved in the recruitment of programmers...
--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)

February 15, 2017 at 9:49 pm

#1928760
RE: Non-ANSI equal join - SQL 2012

Lynn Pettis - Wednesday, February 15, 2017 10:08 AM
Sue_H - Tuesday, February 14, 2017 3:54 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)

February 15, 2017 at 9:22 pm

#1928757
RE: Can anyone recommend a working sample ETL package created with SSIS?

halifaxdal - Wednesday, February 15, 2017 12:34 PM
I am looking for a working package, I came across this one from Microsoft's Tutorial,...
--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)

February 15, 2017 at 9:16 pm

#1928754
RE: How do page splits work with large amounts of sequential data inserted in the middle?

Sioban Krzywicki - Wednesday, February 15, 2017 10:14 AM
Let's say I have a table with a large number of records that has...
--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)

February 15, 2017 at 9:12 pm

#1928753
RE: Performance improves after reboot

RVO - Wednesday, February 15, 2017 9:22 AM
We reboot the whole server (Windows 2012 Server box).
Yes, It's shared memory and I pointed...
--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)

February 15, 2017 at 3:56 pm

#1928744
RE: Read multiple .sql files having issues with .cmd script :(

The next level of simplification exists in the following command... have a look.
https://technet.microsoft.com/en-us/library/cc753551(v=ws.11).aspx
--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)

February 14, 2017 at 6:26 pm

#1928532
RE: Query fills tempdb after upgrade from 2005 to 2012

TheSQLGuru - Tuesday, February 14, 2017 5:16 PM
jamie_collins - Tuesday, February 14, 2017 2:46 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)

February 14, 2017 at 5:49 pm

#1928529
RE: Performance improves after reboot

RVO - Tuesday, February 14, 2017 11:25 AM
Jeff,
Is Kevin G. Boles specialty - performance issues?
What is the best way to contact Kevin?
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)

February 14, 2017 at 5:45 pm

#1928528
RE: Reducing the size of a 500 Gb database on standard edition

ffarouqi - Tuesday, February 14, 2017 4:11 PM
GilaMonster - Tuesday, February 14, 2017 4: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)

February 14, 2017 at 4:53 pm

#1928521

Viewing 15 posts - 15,631 through 15,645 (of 59,097 total)