Viewing 15 posts - 331 through 345 (of 1,179 total)
I think this is the normal scenario of blocking and once either process id completes the update it release the lock. Might be the lock/block is temporary here.
As profiler...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 6:06 am
Are you using FILESTREAM?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 5:45 am
What datatype are you using for 'File Name'?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 4:19 am
In addition to Koen; you can also drop all constrains on the destination table if no. of rows are more which will expedite the process. Once SSIS is done you...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 4:09 am
Following are the extract from the BOL:
To determine whether a package exists in the local file system, use the following syntax:
dtutil /FILE c:\srcPackage.dtsx /EXISTS
To determine whether a package exists in...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 3:38 am
Very interesting question, Thanks!
Also one can try restarting sql server (test only) and execute the query it will give you 0 record and later 5 rows.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 3, 2014 at 1:19 am
Can you provide detail or technical link for 3D joins in 2014?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 5:37 am
Does your maintenance run at this time?
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 5:23 am
Refer following link:
http://technet.microsoft.com/en-us/library/ms175527(v=sql.105).aspx
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 4:26 am
As far as I know if you do have different set of LUNS assigned to different drives than it will be useful; else even though you do have different drives...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 3:47 am
Is it possible to run DBCC CHECKTABLE on which you feel that table having index related error. Also it would be good if you can run DBCC CHECKDB to make...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 3:29 am
Carlo Romagnano (4/2/2014)
In sqlserver 2008 r2 the update doesn't return any resultset and no error message.(2 row(s) affected)
(2 row(s) affected)
What I'm missing?
I have executed in SQL 2012 and got the...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 3:29 am
dawryn (4/2/2014)
Tricky again :doze: Some important information missing4 obvious choices and then you have to :Whistling: guess which one of remaining correct options was taken for the right one :pinch:
+1
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 1:12 am
Day by day QotD becomes difficult.
While executing update we didn't receive any result set; we got message only!!!
I guess there is difference it result set and message.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 2, 2014 at 1:10 am
Usually I do not change default setting of system databases.
About user database based on the db size and data growth you can set auto growth option but I suggest...
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 1, 2014 at 6:27 am
Viewing 15 posts - 331 through 345 (of 1,179 total)