Jeff Moden

Forum Replies Created

Viewing 15 posts - 22,366 through 22,380 (of 59,102 total)

RE: Point in time restores referencing copy-only backups?

slimchance99 (11/27/2014)
The reason is that the daily copy-only backups are performed at the data centre onto their backup media as part of the enterprise DR plan. If we have 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)

November 27, 2014 at 1:37 pm

#1761348
RE: Release

river1 (11/27/2014)
When will SQL Server 2014 will be released to be installed in production.
I mean, when will I have a version that I can trust to put in production?
Thanks
Never. ...
--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 27, 2014 at 1:17 pm

#1761345
RE: Point in time restores referencing copy-only backups?

slimchance99 (11/25/2014)
On one of our SQL Server 2014 boxes each database has a copy-only full backup made every night, in addition to the maintenance plan schedule of a full backup...
--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 27, 2014 at 1:08 pm

#1761344
RE: Thanksgiving 2014

Heh... "Happy Bird Day" Steve!
--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 26, 2014 at 8:59 pm

#1761196
RE: Shrinking Database for Dev Environment

peteroc (11/26/2014)
Hi Luis,
We're freeing up 25% of the space as we're removing a lot of image data but it's still a big database (115gb) with 150m rows of data across...
--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 26, 2014 at 8:55 pm

#1761195
RE: Active Directory

m_ahmed2000 (11/11/2014)
(a)The zip file servers_svcaccounts_110814.zip contains a text file for each server on the domain. Each text file has the services and service accounts for the server. Unzip...
--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 26, 2014 at 8:37 pm

#1761193
RE: Running total

GrassHopper (11/26/2014)
Check the post I made with the desired results.jpg It is explained there and shows where the volume comes from.
Ah... got it. Without the penny per row...
--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 26, 2014 at 8:25 pm

#1761192
RE: Please vote for the "built in Tally Table" function.

Erland Sommerskog noticed the hits on the CONNECT item and posted on the MVP email "forum". Let's hope MS notices, as well.
Until I can get Steve to publish 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 26, 2014 at 8:21 pm

#1761191
RE: Please vote for the "built in Tally Table" function.

Luis Cazares (11/26/2014)
Jeff Moden (11/25/2014)
Thanks Koen and Eirikur!
How about it folks? There a 1.7 million of you out there. Can we get a few more votes 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 26, 2014 at 8:08 pm

#1761190
RE: Running total

You might want to tell them of the mistake I think they're making.
Back to the issue at hand, where does the "60" limit come from in your original JPG and...
--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 26, 2014 at 4:07 pm

#1761181
RE: t-sql to create simple bar graph image file to be inserted into email

Crud. This looks very interesting. I've been playing with SVG generation in T-SQL and this looks a whole lot easier than what I've been doing.
I say "crud" because...
--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 26, 2014 at 3:26 pm

#1761177
RE: Junk/SPAM Posts Overwhelming

Hi Melanie,
Clearly, the good efforts of the team just aren't working. Last weekend, the "Posts Added Today" link was so flooded with spam, all of the people who needed...
--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 26, 2014 at 3:12 pm

#1761174
RE: Running total

GrassHopper (11/26/2014)
The answer to your question is that when the Running total is greater than the Volume total (60), instead of entering in the running total amount, you calculate 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)

November 26, 2014 at 3:03 pm

#1761172
RE: interview questions

rahul.neekhra 81176 (11/26/2014)
Hi,
Find the interview questions and answers here http://www.sqlserverpeoples.com/Examples.aspx
I've been to that site before and was appalled at the answers and examples. As Gail pointed out, there's 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 26, 2014 at 8:36 am

#1761120
RE: Creating a Query to show data side by side

I believe the OP is asking how to display 3 groups of columns like you might find in a phone book.
--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 26, 2014 at 8:19 am

#1761106

Viewing 15 posts - 22,366 through 22,380 (of 59,102 total)