Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,601 through 15,615 (of 59,063 total)

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
RE: Reducing the size of a 500 Gb database on standard edition

ffarouqi - Tuesday, February 14, 2017 11:52 AM
One of my clients has requested to find any options to reduce the size 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)

February 14, 2017 at 1:16 pm

#1928482
RE: Performance improves after reboot

The number you're looking for is the 360 that was returned.
--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 1:03 pm

#1928479
RE: Sql Server "Runbook" !

Are they simply talking about the "runs" that are done via scheduled jobs?
--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 1:01 pm

#1928478
RE: Running date update

So how long does the update through the CTE take for 1 million out of the 6.5 million rows now?
--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 9:12 am

#1928397

Viewing 15 posts - 15,601 through 15,615 (of 59,063 total)