Jeff Moden

Forum Replies Created

Viewing 15 posts - 16,696 through 16,710 (of 59,067 total)

RE: CONVERT DATETIME to TIME and remove seconds and milliseconds

Sergiy (10/5/2016)
drew.allen (10/5/2016)
How about just changing the declaration of @StartTime2 to SMALLDATETIME?
Drew
How about not splitting date and time for StartDateTime?
😀
+1000 🙂
--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)

October 5, 2016 at 7:38 pm

#1905078
RE: Unable to TRUNCATE TABLE, a permissions issue (I think)

bmg002 (9/27/2016)
Sean Lange (9/27/2016)
bmg002 (9/27/2016)
you are already doing that.
if you are using 3 values in the object declaration, you are declaring the database, the schema and the object.
so in 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)

October 5, 2016 at 7:21 pm

#1905075
RE: Server and users on different Domain..good or bad

RVO (10/3/2016)
I guess the TRUST is there.
Because we use Windows Authentication to access SQL Servers on the other domain.
Users in BLL domain.
SQL Server in BLL-SG domain.
But this kind of setup...
--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)

October 5, 2016 at 7:09 pm

#1905074
RE: Backup Permissions and User

szejiekoh (10/3/2016)
thank you guys! yeap i have also done the tests and observed the same behavior :w00t:
I'm curious. You would have had to try this out anyway. Why...
--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)

October 5, 2016 at 7:05 pm

#1905073
RE: System objects could not be updated in database 'x' because it is read-only.

le.kinou (9/30/2016)
Hello,
If we do not switches back to READ_WRITE in order to perform system objects updates
=> Is there a risk ?
Thanks
I've not yet run into this problem 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)

October 5, 2016 at 7:02 pm

#1905072
RE: Backing up User and System databases at the same time

Grant Fritchey (9/29/2016)
I'd just do them one after another.
Same here. I've worked on many systems that do "parallel" backups of one form (two or more concurrent jobs) or...
--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)

October 5, 2016 at 6:26 pm

#1905070
RE: Recommendation for better perfromance

ramyours2003 (10/4/2016)
HI
I need recommendations for better performance of sql .we have 32bit SQL servers and want to make sure we have them configured optimally for performance....
--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)

October 5, 2016 at 5:58 pm

#1905064
RE: Are the posted questions getting worse?

george sibbald (10/5/2016)
well that's me done. I retire today so this will be my last post.
I made it into the top 30 posters at one point so I did my...
--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)

October 5, 2016 at 2:30 pm

#1905027
RE: Today's Random Word!

whereisSQL? (10/4/2016)
Manic Star (10/4/2016)
djj (10/3/2016)
Ray K (10/3/2016)
Ed Wagner (10/3/2016)
Revenant (10/3/2016)
Grumpy DBA (10/3/2016)
Ed Wagner (10/3/2016)
Quantity
Quality
Life
Family
Guy
Gal
Offspring
Wannabe
Interview
--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)

October 4, 2016 at 10:28 am

#1904697
RE: Looping through rows and applying a count

The only time that performance takes a back seat for me is if accuracy is not otherwise able to be achieved.
--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)

October 4, 2016 at 10:27 am

#1904696
RE: Looping through rows and applying a count

TheSQLGuru (10/4/2016)
watto84 (10/3/2016)
Problem solved on the large data set, i worked out I just needed to apply a clustered index to my table 🙂 Sorry.....Newbie 🙂
Thanks for your help though,...
--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)

October 4, 2016 at 8:03 am

#1904664
RE: Alerting if table is empty

ramana3327 (10/3/2016)
Hi All,
I am looking for a way to get an alert from SQL Agent if any table is empty in a database with the name of the table.
I believe...
--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)

October 3, 2016 at 7:35 pm

#1904584
RE: Backup database only if changes happen

Chandu-212374 (9/28/2016)
I have SQL2008 database with some 100s of tables. Every 2 hours transaction log backup to tape is triggered. Just to save network bandwidth, i would like to 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)

October 3, 2016 at 7:20 pm

#1904582
RE: Maximum number of CROSS APPLY functions

The Dixie Flatline (10/3/2016)
While we're on the subject, does anyone know of a reason there could be a performance hit from doing all these cross applies? I'm...
--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)

October 3, 2016 at 4:42 pm

#1904577
RE: Are the posted questions getting worse?

Lynn Pettis (10/3/2016)
...just don't want to move at the moment.
Seems odd to hear you say that since you voluntarily re-upped for your overseas gig in the past, IIRC.
--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)

October 3, 2016 at 3:57 pm

#1904572

Viewing 15 posts - 16,696 through 16,710 (of 59,067 total)