Jeff Moden

Forum Replies Created

Viewing 15 posts - 15,211 through 15,225 (of 59,097 total)

RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Monday, April 10, 2017 8:03 AM
Jeff: Again circling back to the same question. I clearly stated that I am...
--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)

April 10, 2017 at 8:32 am

#1937449
RE: Adding More Power

TomThomson - Sunday, April 9, 2017 12:06 PM
Jeff Moden - Tuesday, April 4, 2017 11:00 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)

April 10, 2017 at 8:17 am

#1937444
RE: Help in finding actual days and hours difference!!!

Ed Wagner - Sunday, April 9, 2017 7:12 AM
One more thing to consider is that the varchar allows invalid data 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)

April 10, 2017 at 8:04 am

#1937438
RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Sunday, April 9, 2017 11:10 PM
Jeff Moden - Sunday, April 9, 2017 11:02 AM
--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)

April 10, 2017 at 7:53 am

#1937432
RE: Archiving or Moving Data

TheSQLGuru - Sunday, April 9, 2017 1:22 PM
I actually like the multiple database notion for such scenarios. With a good naming scheme...
--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)

April 10, 2017 at 7:47 am

#1937431
RE: Running Total

DesNorton - Sunday, April 9, 2017 11:57 PM
Jeff Moden - Friday, April 7, 2017 11:48 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)

April 10, 2017 at 7:43 am

#1937428
RE: Are the posted questions getting worse?

TomThomson - Sunday, April 9, 2017 11:49 AM
Sean Lange - Tuesday, April 4, 2017 10:50 AM
--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)

April 10, 2017 at 7:35 am

#1937426
RE: By Design

Heh... I rank the term "By Design" and, especially, the term "Operates as Designed" right up there with other "lameties" (to coin a phrase and is similar to the well...
--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)

April 9, 2017 at 11:25 am

#1937351
RE: Query to backup the databases on a SQL instance using a config table

ffarouqi - Saturday, April 8, 2017 11:41 PM
Hi Folks,
I am looking for a script that would help me take the backup 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)

April 9, 2017 at 11:02 am

#1937349
RE: Query to backup the databases on a SQL instance using a config table

Igor Micev - Sunday, April 9, 2017 5:41 AM
Why don't you want to go with ola's scripts? Maybe you should read more...
--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)

April 9, 2017 at 10:27 am

#1937348
RE: Archiving or Moving Data

I did the same thing with a similar table, which contains the binary for a WAV file for recorded calls. It currently contains 91 months (we have to keep everything...
--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)

April 9, 2017 at 10:24 am

#1937347
RE: SQL Help - How do I get a list of all the DB names in the server and a list of SCHEMAS that belong to each DB

I'm a little bit old fashioned... and a bit of a control freak when it comes to such things, not to mention being a bit anal about formatting and readability...
--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)

April 8, 2017 at 8:48 pm

#1937334
RE: creating objects in master or msdb database

A better practice would be to create a small "utility" database for such things.
To be honest, though... you don't need a separate table to do comparisons with. 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)

April 8, 2017 at 6:55 pm

#1937332
RE: Increase Disk Space on Data Drive

stephen.godwin - Friday, April 7, 2017 12:10 PM
As is common, I inherited this mess. The test server is almost complete, i just...
--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)

April 8, 2017 at 6:42 pm

#1937331
RE: Good Referrence For Evaluate SQL Server vs Oracle

IMHO, there is no totally reliable, unbiased, completely accurate comparison except possibly for the cost of ownership.
There are a lot of folks that will say that MS has created...
--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)

April 8, 2017 at 4:20 pm

#1937329

Viewing 15 posts - 15,211 through 15,225 (of 59,097 total)