Jeff Moden

Forum Replies Created

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

RE: Please help ... Attaching all files in a folder to an e-mail

If you don't need the file details like the date created or size, then you can use xp_DirTree to get a list of the files instead of a CLR. ...
--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 3:08 pm

#1668993
RE: Question for DBAs - Manage SQL Jobs

keyun21 (11/25/2013)
Their response is to go and figure out yourself.
Not exactly "Exceptional DBAs", in my book. :blink: The link that Lowell provided is definitely the place to start.
--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 3:00 pm

#1668992
RE: Backup Time vs Restore Time

I have a 141GB database that takes 00:31:05 to backup and and 01:31:27 to restore. I don't know if the 3:1 ratio exists elsewhere but, as you can see,...
--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 2:22 pm

#1668976
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

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