Viewing 15 posts - 6,376 through 6,390 (of 22,211 total)
Don't use up all the space on any of your drives. Always have a one or two mb file called "deletemeinemergencies.txt" that you can use to gain a little space...
April 10, 2015 at 4:24 am
Oh, and don't try to move them out the room. You only have 15 minutes. You can't move kids anywhere in less than 10 minutes.
April 9, 2015 at 3:47 pm
Here's an idea. Something similar to this could work. We did a "deployment" by blowing up balloons, not tieing them off and then asking the audience to get it...
April 9, 2015 at 3:46 pm
Sean Lange (4/9/2015)
sqlfriends (4/9/2015)
Just curious if SQL server have ability to...
April 9, 2015 at 3:32 pm
That's tough, but for a 10 minute presentation, focus on communicate a single idea. Don't try to cover too much. You want to show the magic of development, find one...
April 9, 2015 at 3:12 pm
It does sound more and more like a bad plan.
April 9, 2015 at 3:08 pm
sqlfriends (4/9/2015)
Just curious if SQL server have ability to do that...
April 9, 2015 at 12:07 pm
Not a problem. Happy to help. You know where to go if you have questions.
April 9, 2015 at 12:04 pm
sqlfriends (4/9/2015)
This table has no...
April 9, 2015 at 10:57 am
I'd suggest more direct control. Write a statement at the beginning that explicitly creates the table using the structure and name you want and then INSERT...SELECT instead of SELECT...INTO.
April 9, 2015 at 10:49 am
Only if it's supplied through the connection string. Which, effectively, means no.
April 9, 2015 at 10:48 am
Why not use GETDATE, or better still, GETUTCDATE, to retrieve the date and time you're doing your edits. You don't need to manually modify a value.
April 9, 2015 at 10:47 am
You mean this book?
Like Gail says, to SQL Server, there's no difference between a client side timeout and you just killing a query that's running in SSMS. Neither one generates...
April 9, 2015 at 10:45 am
tcronin 95651 (4/9/2015)
April 9, 2015 at 8:46 am
Jeff Moden (4/9/2015)
Grant Fritchey (4/9/2015)
Check Database IntegrityDatabase Backups
Log Backups
Backup Testing
Statistics Maintenance
Index Maintenance
Those are the basics I think.
Just to add to that fine list... Checks on performance and resource usage (usually...
April 9, 2015 at 8:45 am
Viewing 15 posts - 6,376 through 6,390 (of 22,211 total)