Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,616 through 24,630 (of 59,099 total)

RE: Query just hangs!

I haven't checked for all of the columns but the original query had a "Hierarchy" column in it, which is missing from the test data. Considering that the triangular...
--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)

January 27, 2014 at 5:25 pm

#1683765
RE: Automatically import csv content into SQL Server

Deries (1/27/2014)
Thank you Jeff, Could you or anyone give me a sample code to test it out.
The link that Luis posted has such sample code in the article.
--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)

January 27, 2014 at 4:20 pm

#1683751
RE: Unable to scheule packages

I guess my question would be, why can't you do this with Windows Authentication and trusted connections?
--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)

January 27, 2014 at 4:19 pm

#1683750
RE: need T-SQL to delete ALL subdirectories within a Directory

Express12 (1/27/2014)
this script did the trick:
-- This step will DELETE "ALL" previously gen'd FULL/DIFF/LOG backup files on T: making space for the new Backup files
--
-- It is needed as 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)

January 27, 2014 at 4:15 pm

#1683749
RE: FizzBuzz

mister.magoo (1/27/2014)
So you didn't get them to explain the rules for a successful quirky update then I guess?
😀
--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)

January 27, 2014 at 3:52 pm

#1683744
RE: FizzBuzz

Shifting gears a bit, in the last 20 interviews that I've conducted, I ask the candidates to wirte code to create and populate a table with all integer values from...
--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)

January 27, 2014 at 12:31 pm

#1683682
RE: Automatically import csv content into SQL Server

Deries (1/27/2014)
I have a CSV & xls file and I'd like import the data from CSV into SQL server existing table efficiently.
This process should be done automatically...
--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)

January 27, 2014 at 12:22 pm

#1683678
RE: View vs sp vs functions

The reason why I'm the one doing the interviews is because these particular companies don't just want "butts in seats". They actually want people that know what they're doing...
--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)

January 27, 2014 at 7:14 am

#1683537
RE: View vs sp vs functions

Lynn Pettis (1/26/2014)
Jeff Moden (1/26/2014)
zi (1/25/2014)
Dear Experts
I want to know differences between views , stored procedures and functions
And when to choose the appropriate one
Thanks lot
Since it was appropriately brought up,...
--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)

January 27, 2014 at 6:49 am

#1683529
RE: Scanning all tables for highest ID

TheSQLGuru (1/26/2014)
>> FROM sys.identity_columns
Thanks for that nugget Jeff - almost 45000 man hours working with SQL Server and still learning!! :w00t:
I'm right there with you, Kevin. 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)

January 26, 2014 at 10:08 pm

#1683416
RE: Minimum privileges

asdsfssd (6/11/2013)
SQL2000
What are the minimum privileges / permissions / database roles needed to grant a user (besides granting sysadmin) to:
1) Create and run DTS packages.
2) Create, run and review job...
--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)

January 26, 2014 at 8:36 pm

#1683412
RE: variable file name in openrowset

In other words, the OPENROWSET that you've created will need to be converted to Dynamic SQL.
--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)

January 26, 2014 at 7:58 pm

#1683410
RE: Scanning all tables for highest ID

squeekz01 (1/26/2014)
Hi guys,
I am looking for help with writing what some may find as a basic query... I need to be able to scan all tables in my database for...
--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)

January 26, 2014 at 7:14 pm

#1683409
RE: QA and DB Design team sleeping in same "bed"?

Barkingdog (1/26/2014)
These changes were unexpected and only completed about 2 days before "review meeting 2"...
I guess I understand their outrage, then. I could be wrong but I've always understood...
--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)

January 26, 2014 at 6:27 pm

#1683405
RE: CTE results storage same as temp table?

smallmoney (1/26/2014)
Simple question, are the results of a CTE stored in the same place as a temp table (tempdb)?
Thanks
As with a View or any query, for that matter, they might...
--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)

January 26, 2014 at 6:08 pm

#1683404

Viewing 15 posts - 24,616 through 24,630 (of 59,099 total)