Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,866 through 20,880 (of 59,072 total)

RE: Running Balance Updation

Ok, here we go. I've added the changes to the million row test data generator that you pointed out for the 0-row balance thing and I made it so...
--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 1, 2015 at 8:19 pm

#1795159
RE: You know you're having a slow day when...

yb751 (5/1/2015)
So I'm browsing the forums and seeing the usual comments like "please provide code and sample data". I'm sitting there and thinking this isn't that hard. 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 1, 2015 at 3:07 pm

#1795128
RE: Are the posted questions getting worse?

I had a rare and wonderful opportunity, today. Luis is in town and I finally got to meet him and have lunch with both him and Ed Wagner. ...
--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 1, 2015 at 12:23 pm

#1795085
RE: Time differences between different intervals

Heh... I cringe every time I see something like this where the human isn't compelled to take an action such a log out. The simple solution above 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 1, 2015 at 8:38 am

#1795006
RE: Finding Problem Code

One of the most obvious yet frequently over looked methods is the reports you can get when you right-click on the instance name in Object Explorer. It's very effective...
--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 1, 2015 at 7:28 am

#1794977
RE: Complete weeks

Eirikur Eiriksson (4/30/2015)
sharonsql2013 (4/30/2015)
I need to divide a number by the number of full weeks based on today's date.
Say today is April 30 which is Week 18th but since its...
--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 1, 2015 at 7:10 am

#1794971
RE: Datediff

Eirikur Eiriksson (4/30/2015)
sharonsql2013 (4/30/2015)
Does datediff hinders performance in queries.
I am trying to access the records and it takes almost 40 seconds to filter out of 180000 rows. Which is not...
--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 1, 2015 at 6:47 am

#1794959
RE: Complete weeks

sharonsql2013 (4/30/2015)
I want the start of the week from 04-12-2015 thru 4-18-2015. (Sat thru Sun)
What should the start of the week for the 1st of January 2015 be 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)

April 30, 2015 at 8:17 pm

#1794887
RE: Monitor Database Growth and if any DB is grown by 20%, sending mail alerts

I'll also add that it'll be a real surprise for someone if you wait for 20% growth on a terabyte database before you report it. 😉
--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 30, 2015 at 3:43 pm

#1794869
RE: Complete weeks

sharonsql2013 (4/30/2015)
That helps..Thanks a lot
Actually, it doesn't. The WEEK datepart doesn't count whole weeks.
--===== Note that the dates below occur on an adjacent Wednesday and Thursday respectively.
SELECT...
--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 30, 2015 at 3:40 pm

#1794867
RE: Time differences between different intervals

ram.vaddiparthi (4/30/2015)
Hi There,
I am using google form which will help me to capture the login,break and other off work related activities. Now, the challenge is how can I get 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)

April 30, 2015 at 3:22 pm

#1794863
RE: Very Large Database Split it or what?

mark.hall (2/23/2010)
SQL 2000 on W2K3
I've got a 200GB database 1 file 1 log. When the DB has to grow it causes the application to wait which causes the 250...
--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 30, 2015 at 3:17 pm

#1794860
RE: Excel Source Opening a rowset for "sheet1$" Failed

tfendt (4/30/2015)
Found the issue. It is indeed a bug with SQL Server. I found this KB article (https://support.microsoft.com/en-us/kb/3008000) that described my exact error message even though the KB article only...
--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 30, 2015 at 2:02 pm

#1794838
RE: Datediff

sharonsql2013 (4/30/2015)
Changed the signed from < to > which was the requirement though. ANd now it pulled up quick
If you continue to use DATEDIFF like that, you continue to compare...
--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 30, 2015 at 1:57 pm

#1794837
RE: Exclude Columns When Using Bulk Insert

anju04n6 (4/30/2015)
thank you for the response Jeff.
I have tried earlier with \r\ n and . I think just before I posted the question I changed it to \r 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)

April 30, 2015 at 1:00 pm

#1794823

Viewing 15 posts - 20,866 through 20,880 (of 59,072 total)