Viewing 15 posts - 3,766 through 3,780 (of 8,753 total)
Further on Tom's fine answer, the uncommitted insert statement will be holding Sch-M lock that prevents concurrent access to the table.
😎
Run this in session 1 to observe the locks held...
March 27, 2016 at 12:23 pm
szejiekoh (3/27/2016)
Thanks for your reply!
So actually SELECT will start a transaction as well...
q1) can you actually let me know what does @@option & 2 means ? ( i...
March 27, 2016 at 10:17 am
Stylez (3/23/2016)
I would like to ask is there a way for me To Optimize the way i insert My Data from A Temp Table To A Sql Table....
March 27, 2016 at 5:32 am
szejiekoh (3/27/2016)
q1) Why am i able to still ROLLBACK after setting implication_transactions off ?
This is simply because the last select within the IMPLICIT_TRANSACTIONS ON section implicitly begins a new transaction...
March 27, 2016 at 4:00 am
Don't think that compression should be applied to everything in a database as sometimes the space gain is marginal which hardly justifies the compression.
😎
Below are two scripts, the first compresses...
March 27, 2016 at 3:09 am
Mac1986 (3/26/2016)
I have source table with column nvarchar(20). the data looks like below.
Duration
120:06:31.150
120:06:31.165
238:21:19.875
266:45:41.472
287:03:25.184
I need to dump it into destination and i do...
March 27, 2016 at 12:15 am
Alan.B (3/25/2016)
Are you really on SQL Server 2008? If you were using SQL 2012 this article would get you 90% there:http://www.sqlservercentral.com/articles/SQL+Server+2012/106903/%5B/url%5D
I would say more like 99.99% there:-D
😎
The article's code...
March 26, 2016 at 5:08 am
VoldemarG (3/24/2016)
March 25, 2016 at 2:08 pm
Sean Lange (3/24/2016)
Thank you Mr. Moden. Another interview cut short with the simple "Name one way to get the...
March 24, 2016 at 7:36 am
Can you post the full DDL for the tables, indices, triggers etc.?
😎
March 24, 2016 at 12:46 am
vs.satheesh (3/23/2016)
I am using date add Query for following method
update OfflineExamScheduleMaster
set edatetime=dateadd(mi,50,getdate()),
I got the result for example...
2016-03-24 11:52:16.207
But i want following format
2016-03-24 11:52:00.000
I want Milli secong and...
March 23, 2016 at 11:56 pm
ChrisM@Work (3/23/2016)
The idea of presenting...
March 23, 2016 at 10:34 am
PJ_SQL (3/23/2016)
Thanks but how would it spread data from the 1st file which is 2 TB to second file created?
1. Create a new file group
2. Add a file to the...
March 23, 2016 at 6:49 am
PJ_SQL (3/23/2016)
I have 3TB database and MDF is 2TB, how to create secondary file?
You can use ALTER DATABASE to add a file, the example below adds a file (64Mb) "MyNewDataFile"...
March 23, 2016 at 6:34 am
Koen Verbeeck (3/22/2016)
In case you're wondering, I'm fine. I didn't have to be in Brussels today, so I avoided all of the commotion...
Glad you are fine mate, still trying to...
March 22, 2016 at 12:56 pm
Viewing 15 posts - 3,766 through 3,780 (of 8,753 total)