Jeff Moden

Forum Replies Created

Viewing 15 posts - 20,896 through 20,910 (of 59,098 total)

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
RE: Datediff

djj (4/30/2015)
Also is there an index on Time_Created?
Also, what is the datatype of the Time_Created column? Could be some nasty ol' implicit conversions working here.
I also agree with Luis.......
--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 10:57 am

#1794794
RE: Reducing Index Fragmentaion during Inserts

kevaburg (4/27/2015)
Hi all!
Many, many thanks for the tips. I have decided to use a combination of the advice given here.
I will add an identity column in the table 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 9:00 am

#1794725
RE: Exercise to practise SQL

pawankkmr 41145 (4/30/2015)
Check out puzzles @
http://msbiskills.com/tsql-puzzles-asked-in-interview-over-the-years/
That's pretty cool. One recommendation would be that if anyone wants to use XML to do a split, you might not want to work...
--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:56 am

#1794722
RE: Running Balance Updation

I was at work until 2AM this morning but I did manage to work on your project a bit. I never provide answers to such important data without 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)

April 30, 2015 at 8:47 am

#1794716

Viewing 15 posts - 20,896 through 20,910 (of 59,098 total)