Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,551 through 20,565 (of 59,072 total)

RE: Storing a Binary File in a Database

Orlando Colamatteo (5/26/2015)
Jeff Moden (5/26/2015)
For those cases where you're not going to violate the 2GB limit, you don't even need FileStream to load binaries.
True, but with in-table storage the cost...
--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)

May 27, 2015 at 12:22 am

#1800757
RE: jobs getting delay in processing the data

Hard to tell with the info you've given. The best I can offer is that you need to continue to work to find the code that is causing 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)

May 27, 2015 at 12:06 am

#1800752
RE: Automatic restore

reynolddejesus100 (5/26/2015)
i have a full backup followed by transaction log every Monday, Wednesday and Friday, how can i restore this file using sql agent to automate restoration of backup files...
--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)

May 27, 2015 at 12:02 am

#1800751
RE: Tuning expensive query II

WhiteLotus (5/26/2015)
GilaMonster (5/26/2015)
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Thanks for the link . NOTED 🙂
I attach the execution plan .
Project text --> Table A
Below query is clearer I think ( The query that I run...
--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)

May 26, 2015 at 11:59 pm

#1800750
RE: Using string functions on Text

Anshul.P (5/26/2015)
Hi,
I've below value in a column with data type - TEXT
QU 221025U2V/AN G-DT DL A 5 1A- 11,5,SF,230,30162,LZ,2,118,0,0,10170,25,06
This text value has some special characters in it. and I...
--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)

May 26, 2015 at 11:53 pm

#1800748
RE: implementing backup system using PS (a newbie question)

GeriReshef (5/26/2015)
Thanks for your answer!
I will try to explain what I'm trying to find..
A year ago I was asked to develop a central system for backups. Till then, for every...
--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)

May 26, 2015 at 11:47 pm

#1800747
RE: A quick query puzzle:

dwain.c (5/26/2015)
pawankkmr 41145 (5/26/2015)
Complete list of Simple and complex t-sql puzzles at
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
This blog is useful for mid level developers , Strictly not for SQL Experts 🙂
Enjoy...
Definitely some interesting puzzles...
--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)

May 26, 2015 at 9:41 pm

#1800738
RE: A quick query puzzle:

pawankkmr 41145 (5/26/2015)
Hi Jeff,
Thank you very much ! Sure will try to improve on Q&As. Will update that post also.
Regards,
Pawan
Thank you for the feedback, Pawan.
--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)

May 26, 2015 at 9:39 pm

#1800737
RE: REPLACE Multiple Spaces with One

Alan.B (5/26/2015)
Jeff Moden (5/26/2015)
Alan.B (5/26/2015)
I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.
Thanks, Alan, but...
--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)

May 26, 2015 at 9:38 pm

#1800736
RE: A quick query puzzle:

Jeff Moden (5/26/2015)
pawankkmr 41145 (5/26/2015)
Complete list of Simple and complex t-sql puzzles at
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
This blog is useful for mid level developers , Strictly not for SQL Experts 🙂
Enjoy...
The problem with...
--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)

May 26, 2015 at 6:07 pm

#1800725
RE: REPLACE Multiple Spaces with One

Alan.B (5/26/2015)
I love this article Jeff and have been using your technique since I discovered this article a little more than a year ago.
Thanks, Alan, but you need 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)

May 26, 2015 at 5:45 pm

#1800724
RE: How to determine metadata on DBCC results

It used to be possible using a "LoopBack" linked server but the latest "improvements" in SQL Server 2012 put the kibosh on all that. Now, all you get 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)

May 26, 2015 at 4:58 pm

#1800720
RE: Virtual log files

Agnii (5/21/2015)
Yea...it seems to be a problem for us....the DB log in question is about 450 GB and with around 12000 vlf files..
That's a fairly large log file. What...
--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)

May 26, 2015 at 4:34 pm

#1800716
RE: import data locate in file => file create with generate script

christophe.bernard 47659 (5/21/2015)
Hi expert :),
I work with sql server 2008 on a database.
we have export schema and datas with the command export datas
click rigth on database => tasks => generate...
--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)

May 26, 2015 at 3:21 pm

#1800709
RE: missing one record when selecting by date range

itortu (5/26/2015)
I changed my original query to use 23:59:59, and that also gave me the missing record back.
You're just asking for a world of hurt in the future. ...
--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)

May 26, 2015 at 11:11 am

#1800651

Viewing 15 posts - 20,551 through 20,565 (of 59,072 total)