Viewing 15 posts - 6,451 through 6,465 (of 13,876 total)
What's the compatibility level of the database you're working in?
October 25, 2016 at 11:50 am
@Patrick123 (10/25/2016)
October 25, 2016 at 10:55 am
Luis Cazares (10/25/2016)
READ COMMITTED should be enough. I would test, though.
Thanks again.
I agree: time to attempt to crash it with some testing.
October 25, 2016 at 10:45 am
Nice, Luis.
Is SERIALIZABLE required in this case? Or would READ COMMITTED be enough?
October 25, 2016 at 10:31 am
ninamahezi (10/25/2016)
I know how to use UPDATE but I was talking about functions in SQL.Thanks very much.
You have your answer. Functions do not perform updates in T-SQL.
October 25, 2016 at 10:18 am
I'd welcome any helpful comments on the optimal handling of concurrency issues in this thread. Cheers!
October 25, 2016 at 10:06 am
dramaqueen (10/25/2016)
I am having issues with the following script. I have 3 tables that link together.
What I need to do is find owners that have items with statuses as...
October 25, 2016 at 7:47 am
sqlserverDBA2016 (10/25/2016)
And can u please tell me how to disable them
Right-click the service you want to disable, select Properties and then, on the General tab, set Startup Type to 'Disabled'....
October 25, 2016 at 6:27 am
sqlserverDBA2016 (10/25/2016)
Thanks mateJust can I confirm, the ssas and ssrs and ssis can they be disabled from services after being installed
Confirmed. Though I tend to use SQL Server Configuration...
October 25, 2016 at 5:38 am
wtren (10/25/2016)
You should use bcp
Please justify this comment.
October 25, 2016 at 4:48 am
sqlserverDBA2016 (10/24/2016)
So u agree that it's better to install it when installing SQL server
If it's a development machine, I wouldn't worry about it one way or the other, but for...
October 24, 2016 at 5:11 pm
40mil in one table
That's manageable. But your original post mentioned 40 miliion million = 40 000 000 000 000 = 40 trillion.
October 24, 2016 at 3:46 pm
sqlserverDBA2016 (10/24/2016)
Is adding the features later same as when installing SQL serverAnd it's not more xomplicated
I think that Jeff's point of view is that it's safer to reconfigure a (working)...
October 24, 2016 at 3:41 pm
komal145 (10/24/2016)
I have a source column value "abcd" , i will be updating the destination column with the source column value only if there is a change.
Example: destination is...
October 24, 2016 at 2:23 pm
.Patrick (10/24/2016)
Currently we are developing a new application for our company and I got a question related to the database architecture. We one database (DatabaseA) that is our main...
October 24, 2016 at 1:23 pm
Viewing 15 posts - 6,451 through 6,465 (of 13,876 total)