Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,331 through 24,345 (of 59,099 total)

RE: To T-SQL or not to T-SQL?

sqldriver (2/18/2014)
Jeff Moden (2/18/2014)
I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to be 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)

February 18, 2014 at 9:48 pm

#1690139
RE: Big transaction log file

MyDoggieJessie (2/18/2014)
What we can ALL AGREE upon is whichever route you take, please DO NOT SKIP STEP #10
Heh... I'll drink to that! 🙂
--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)

February 18, 2014 at 9:37 pm

#1690137
RE: 15 minutes Interval from Hours - Please Help

zulfansari (2/18/2014)
Hi Guys,
I'm sorry about the confusion, I guess I should take it step by step, first I need to add a total column as the last column so then...
--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)

February 18, 2014 at 9:32 pm

#1690135
RE: Big transaction log file

SQLRNNR (2/18/2014)
The real answer is "It Depends"
How important is the data to your company/client? Do they have an RTO/RPO specified? In other words, what is the maximum allowable...
--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)

February 18, 2014 at 3:14 pm

#1690081
RE: compare 2 rows next each other

Post withdrawn. I thought this was going to turn out to be a massive double triangular join but a second look-see says it probably won't.
--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)

February 18, 2014 at 3:04 pm

#1690075
RE: Big transaction log file

cygne17_2 77208 (2/18/2014)
Hi,
I found a sql server database with a transaction log file of 65 GB.
The database is configured with the recovery model option = full.
Also, I noticed than 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)

February 18, 2014 at 2:53 pm

#1690066
RE: To T-SQL or not to T-SQL?

I guess I don't understand the need for any preprocessing here. Just load the each group of files into a working table (heaps, to be sure) and do your...
--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)

February 18, 2014 at 2:44 pm

#1690060
RE: Query all schemas.

jiayi345 (2/18/2014)
Say I have 100 schemas all with the table "orders" is there an easy way to write one query to query them all?
cust1.orders
cust2.orders
cust3.orders
cust4.orders
etc...
Yes... write a spot of dynamic SQL...
--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)

February 18, 2014 at 11:10 am

#1690004
RE: MSDB Transaction Log filling very fast..

IIRC correctly, there was a bug that cause this behaviour depending on the INITIAL SIZE and GrOWTH SETTINGS of a database in SQL Server 2005. I believe that SP3...
--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)

February 18, 2014 at 9:04 am

#1689958
RE: Did This Work? - Forum Changes at SQLServerCentral

Steve Jones - SSC Editor (2/18/2014)
Jeff Moden (2/16/2014)
As I stated peviously, the OP is frequently the worst person to judge answers. You have to remember that they asked 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)

February 18, 2014 at 8:47 am

#1689949
RE: DateAdd - Show past year, 2 years, 3 years

tonyabrhm (2/18/2014)
Hi
I am trying to create a query which shows data from the past 1, 2, 3 4 and 5 years in seperate columns. I beleive I have the within...
--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)

February 18, 2014 at 8:41 am

#1689947
RE: Missing Indexes

BrainDonor (2/18/2014)
mandir.jain (2/18/2014)
one scenario may benefit from creating ,other scenarios may not. So how to decide ? how many scenarios to test? 🙂
Indeed. And somebody has to make the decision...
--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)

February 18, 2014 at 8:37 am

#1689942
RE: Finding hierarchy errors

Once you have all of the problems resolved with the "non-existing parent" problem, you should add a self-referencing FK that contrains the values of parentIDs to only those values available...
--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)

February 18, 2014 at 8:12 am

#1689928
RE: Help with Query Output

kalikoi (2/18/2014)
I have three tables as follows
TableA
------
Col1 col2 col3
1 C01 1
2 C02 2
3 C03 1
4...
--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)

February 18, 2014 at 6:52 am

#1689882
RE: Idera SQL Safe tool help - how to remove records from the repository or from alerts

My recommendation would be to see if the built in "Help" for Idera might save you some time. It's most likely that pressing the {f1} key while the tool...
--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)

February 18, 2014 at 6:49 am

#1689880

Viewing 15 posts - 24,331 through 24,345 (of 59,099 total)