Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,321 through 25,335 (of 59,099 total)

RE: Core T-SQL

rlortega (11/25/2013)
So what minimum T-SQL skills are necessary if you're a DBA, not a developer?
To be honest... learning to read minds and to anticipate "what's coming" by keeping in contact...
--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 25, 2013 at 12:04 pm

#1668931
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

Sean Lange (11/25/2013)
Kurt W. Zimmerman (11/25/2013)
Jeff Moden (11/24/2013)
Neither. I use dynamic SQL with two TOPs in dynamic SQL and get returns in less than 500 ms from a...
--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 25, 2013 at 10:32 am

#1668895
RE: Core T-SQL

ojrodriguez (11/24/2013)
Best Practices
Actually, that's an oxymoron from what I've seen. 😉
--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 24, 2013 at 7:32 pm

#1668710
RE: I want to be a DB Admin

My feeling is that unless you have gone through the throws of being a good database developer, you won't be all that you could be as a DBA.
--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 24, 2013 at 7:16 pm

#1668709
RE: What is SQL Server not good at?

ccd3000 (11/22/2013)
Absolutely. Over the last few years, it's one of the first questions I ask vendors about their products. To me it's similar to knowing when not to use my...
--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 24, 2013 at 7:08 pm

#1668708
RE: Automate Pulling off agent Jobs to File

jameslauf (11/22/2013)
I have been asked to go through all our SQL Servers and pull a copy of all the SQL Server Agent Jobs off to a file.
Unless they told 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 24, 2013 at 6:57 pm

#1668707
RE: Which way is better in SQL Paging (With or TempTableVariable) & Why ??

ahmedhussein874 (11/21/2013)
Which way is better in SQL Paging and Why ??
With
WITH MyCte AS
(
SELECT EmployeeID, EmployeeName, Age, Position, Address, PhoneNumber
,ROW_NUMBER() OVER (ORDER BY EmployeeID) AS RowNumber
FROM dbo.Employees
)
SELECT *
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)

November 24, 2013 at 6:53 pm

#1668705
RE: How to split filegroup files to more than physical storage drive

MohamedDBA (11/24/2013)
Are I can spread my database filegroup files to more than storage drive , not on the same storage drive , and stay connected logically as if they in...
--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 24, 2013 at 6:49 pm

#1668704
RE: Core T-SQL

ojrodriguez (11/24/2013)
This doesn't sound unreasonable either but, want to ask you is, what should one add to one's skill set to become an expert?
1. Common sense.
2. Logic.
3. Ownership of a...
--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 24, 2013 at 6:44 pm

#1668702
RE: Still cannot figure passing a variable to procedure

Oracle765 (11/24/2013)
what other way round is there
There might me a thousand different ways but I can't tell because you didn't answer my simple question. What is in @Installations?
--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 24, 2013 at 6:39 pm

#1668700
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Solomon Rutzky (11/23/2013)
So you don't want to run any 3rd party code without having the source code and compiling it yourself?
Correct.
Ok. Do you have source code for 3rd party...
--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 24, 2013 at 11:51 am

#1668672
RE: Bulk insert from file having varying number of columns

Sorry for the late response. I lost track of this thread. Do you still need help on this?
--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 23, 2013 at 4:54 pm

#1668627
RE: Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents

Solomon Rutzky (11/23/2013)
How can we tell there's no backdoor in the assembly?
I feel that this is an odd and unfounded fear that many people seem to have. Why would...
--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 23, 2013 at 4:16 pm

#1668624
RE: Are the posted questions getting worse?

Revenant (11/22/2013)
Jeff Moden (11/22/2013)
I'm, very thankfully, not currently in a postition like Lynn where I need to find a job because I wouldn't even consider working for a company like...
--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 22, 2013 at 8:08 pm

#1668582
RE: Are the posted questions getting worse?

Stefan Krzywicki (11/22/2013)
Jeff Moden (11/22/2013)
I'm, very thankfully, not currently in a postition like Lynn where I need to find a job because I wouldn't even consider working for a company...
--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 22, 2013 at 8:04 pm

#1668580

Viewing 15 posts - 25,321 through 25,335 (of 59,099 total)