Forum Replies Created
Viewing 15 posts - 18,961 through 18,975 (of 59,098 total)
-
RE: Daily Database Backup Scripts
Michael L John (12/18/2015)
Jeff Moden (12/17/2015)
My personal opinion is that you're not really a DBA unless you have a deep understanding of the various types of backups and restores. ...--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) -
RE: Daily Database Backup Scripts
My personal opinion is that you're not really a DBA unless you have a deep understanding of the various types of backups and restores. I think that every 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) -
RE: How to dynamically create 12 rows per customer in a SQL Table
pete.ciskanik (12/17/2015)
I have a staging table of customer names, numbers, and sales data etc. I've been trying to write a stored procedure that inserts everything into that staging table. One...--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) -
RE: DBA Tasks - To automate or use my own eyes
Johnny B (12/17/2015)
Hi,I've been asked to check the jobs and sql logs for 6 production servers. Two of them are SQL2000 the rest 2008 R2. I don't mind doing 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) -
RE: Are the posted questions getting worse?
Alan.B (12/17/2015)
The quote here should be the same as it is for any busy DBA....
"Stop it Yoda! Get OFF! Osha has declared that if one more person rides...
--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) -
RE: Snapshot Replication Issue in T-LOG
Do you have transaction log backups running on both servers?
--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) -
RE: Is the sa account out of fashion?
The "SA" account is well known to all hackers and the best recommendation is to give a strong password and then disable it. It's OK to build a back...
--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) -
RE: Backup and Restore Plan
Personally, I'm a BIG fan of xp_CmdShell and I might be missing something but... I don't see you actually using it anywhere in your scripts.
Also, it might give everyone 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) -
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets
Alan.B (12/16/2015)
I'm doing my first adjacency list to nested sets conversion and building out a rather complex hierarchy table for a new project (something I've been anxious to do since...--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) -
RE: The Years of Experience
Wayne West (12/15/2015)
Beatrix Kiddo (12/15/2015)
... * the pay wasn't great and the politics were terrible :-D.I think if I had Beatrix Kiddo working in my office, I'd make EXTRA SURE...
--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) -
RE: Simultaneously transaction Update on different Database
Are these two databases on the same server\instance?
--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) -
RE: Convert Rows into Columns
pcanino70 (12/14/2015)
I did some further analysis on Jeff Moden's example and I'm convinced his cross tab method is the proper way to go, I just converted a query that is...--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) -
RE: Incremental Loading using SSIS
RonKyle (12/16/2015)
there are a lot of BI developers who simply won't move data using T-SQL tasks, even when you point out that it's easier to code and 10x as fast....
--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) -
RE: How to pad a string with spaces when size of data is unknown
ChrisM@Work (12/15/2015)
Jeff Moden (12/12/2015)
ChrisM@Work (12/10/2015)
Jeff Moden (12/9/2015)
ChrisM@Work (12/9/2015)
suvesh.sonker 2691 (12/9/2015)
-- Ten digitDeclare @field as varchar(20) = '559'
Select Replace(right(replicate(' ',10) + @field ,10),' ','0')
In what circumstances might this be preferable to...
--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) -
RE: Are the posted questions getting worse?
Ed Wagner (12/16/2015)
WayneS (12/16/2015)
Jeff Moden (12/16/2015)
Steve Jones - SSC Editor (12/15/2015)
Jeff Moden (12/15/2015)
@steve-2,According to your blog, you might show up in Cleveland SQLSaturday for 2016. Any way of knowing...
--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)
Viewing 15 posts - 18,961 through 18,975 (of 59,098 total)