Viewing 15 posts - 16,696 through 16,710 (of 59,067 total)
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 7:38 pm
bmg002 (9/27/2016)
Sean Lange (9/27/2016)
bmg002 (9/27/2016)
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 7:21 pm
RVO (10/3/2016)
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 7:09 pm
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 7:05 pm
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 7:02 pm
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 6:26 pm
ramyours2003 (10/4/2016)
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
Change is inevitable... Change for the better is not.
October 5, 2016 at 5:58 pm
george sibbald (10/5/2016)
I made it into the top 30 posters at one point so I did my...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 5, 2016 at 2:30 pm
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)
QuantityQuality
Life
Family
Guy
Gal
Offspring
Wannabe
Interview
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2016 at 10:28 am
The only time that performance takes a back seat for me is if accuracy is not otherwise able to be achieved.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2016 at 10:27 am
TheSQLGuru (10/4/2016)
watto84 (10/3/2016)
Thanks for your help though,...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 4, 2016 at 8:03 am
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
Change is inevitable... Change for the better is not.
October 3, 2016 at 7:35 pm
Chandu-212374 (9/28/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2016 at 7:20 pm
The Dixie Flatline (10/3/2016)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 3, 2016 at 4:42 pm
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
Change is inevitable... Change for the better is not.
October 3, 2016 at 3:57 pm
Viewing 15 posts - 16,696 through 16,710 (of 59,067 total)