Viewing 15 posts - 2,236 through 2,250 (of 2,857 total)
Where is this information coming from?
I am assuming that "Databases_Leaf" is a list of databases that will be coming from an external source and not the internal set...
October 11, 2017 at 9:56 am
I know as the DBA where I work, if a script has errors when run, I run the rollback script and then contact the developer. We have a "No script...
October 10, 2017 at 10:51 am
If the data in the table is changing frequently, the statistics should be updated frequently.
Basically the statistics are used to determine which plan should be used when performing...
October 6, 2017 at 8:00 am
Adding to what Steve said, I think that this also falls under the "it depends" pile. Having up to date statistics is important for sure, but knowing if indexes are...
October 5, 2017 at 2:51 pm
I tried this on SQL 2008 R2, 2012 and 2016 (slightly modified script) and could not reproduce this.
My script was a lot more simple:SELECT SYSDATETIME()
GO...
October 5, 2017 at 8:37 am
October 5, 2017 at 8:18 am
Is there a reason you want to uninstall? I have found that if you integrate SQL Server into any other tool (such as Visual Studio) or if you install updates...
October 4, 2017 at 4:11 pm
October 2, 2017 at 11:40 am
With the link I provided, I think you'd just need to run things through twice. Using the code in the link and assuming the [city] column is there twice, something...
September 29, 2017 at 11:27 am
If I understand your request properly, I THINK that this will do exactly what you are asking, no:
http://sqljason.com/2010/05/converting-single-comma-separated-row.html
It uses cross apply and you don't need to worry...
September 29, 2017 at 10:55 am
As much as I don't recommend this method, I believe it should be possible if you don't mind using a stored procedure for selecting from or insterting into the table.
September 28, 2017 at 9:21 am
The first thing I would do is a tail log backup and then restore your backups to a secondary system (if available) to see if there is any data in...
September 26, 2017 at 3:58 pm
Thanks for the follow up.
I'm curious what the cause of the problem is and am hoping that we can be of some help in resolving it.
September 26, 2017 at 8:15 am
Did this happen again? If so, did you figure anything out?
September 25, 2017 at 11:13 am
Just happened again to me. I got a notice that a user I know I'm not following (BOR15K) posted, but it claims I am following them.
September 20, 2017 at 12:33 pm
Viewing 15 posts - 2,236 through 2,250 (of 2,857 total)