Viewing 15 posts - 3,886 through 3,900 (of 22,211 total)
Write a blog post on backups. Two reasons. It gets you started. People still don't do backups correctly, if at all, so your addition to the accumulated avalanche of information...
April 19, 2017 at 7:00 am
General advice, completely and utterly ditch the views in views that join to views with however many other views being called. That's a very bad code smell. It causes all...
April 19, 2017 at 6:53 am
April 18, 2017 at 12:28 pm
bmg002 - Tuesday, April 18, 2017 10:47 AMI would run:SET STATISTICS IO ON
SET STATISTICS TIME ON
Exercise caution with this. STATISTICS...
April 18, 2017 at 12:08 pm
April 18, 2017 at 10:40 am
April 18, 2017 at 7:28 am
April 18, 2017 at 7:16 am
It's likely to be WILDLY inaccurate, but you can also query the sys.dm_exec_query_stats to see if there's mention of the database in any of the queries that are currently in...
April 17, 2017 at 6:39 am
Sorry, I've been away from the keyboard. Looks like Jeff has nailed it. Great advice, especially on the view calling a view thing. That seriously over complicates things and leads...
April 15, 2017 at 4:27 am
April 14, 2017 at 5:32 am
Thanks for posting the solution that worked for you. Glad it all worked out too.
April 13, 2017 at 6:43 am
John Mitchell-245523 - Thursday, April 13, 2017 3:44 AM...You can write a PowerShell script...
This.
And do it using the backup & restore mechanisms...
April 13, 2017 at 5:51 am
April 13, 2017 at 5:48 am
Folks,
I have inherited a table with 80K-100K records. Mostly, patient demographic data so, the columns...
April 13, 2017 at 5:45 am
April 12, 2017 at 8:00 am
Viewing 15 posts - 3,886 through 3,900 (of 22,211 total)