Viewing 15 posts - 556 through 570 (of 2,894 total)
Sergiy (3/18/2013)
Eugene Elutin (3/18/2013)
:w00t::w00t::w00t::w00t::w00t:"extra words" is a greatest argument to declare a "code" winner I'have ever seen.
Did you find anything else different?
Anything?
If you missed it - I responded on this...
March 18, 2013 at 5:09 pm
Welcome to the forum!
Unfortunately , details provided with your question are not sufficient enough to make any helpful suggestions - only guesses, which quite often will be irrelevant. Therefore, I...
March 18, 2013 at 11:37 am
Your MGH\sqlagent should have full-control access to the folder on your "different server".
Also, check if you can ping your "different server" from the SQL one.
March 18, 2013 at 11:28 am
Grant Fritchey (3/18/2013)
Eugene Elutin (3/18/2013)
Grant Fritchey (3/18/2013)
... or two as well.Googled out the second one (surprisingly to me - based on "stock management":
OK. For a lock control system...
March 18, 2013 at 11:13 am
What is current settings of your SQL Server (max server memory)?
March 18, 2013 at 10:40 am
Oops, too many windows. Post edited!
Actually, the code version you have seen for window 2, was a good code example, which would work properly with any isolation level...
March 18, 2013 at 10:14 am
Grant Fritchey (3/18/2013)
... or two as well.
Googled out the second one (surprisingly to me - based on "stock management":
March 18, 2013 at 10:10 am
Grant Fritchey (3/18/2013)
opc.three (3/18/2013)
Eugene Elutin (3/18/2013)
If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.
For clarity READ_COMMITTED_SNAPSHOT is just a mode of the READ_COMMITTED isolation...
March 18, 2013 at 10:02 am
kapil_kk (3/18/2013)
Eugene Elutin (3/18/2013)
SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )FROM yourtable
GROUP BY TransactionID
can you plz explain me how Min, MAX is working with alphanumeric values like 'VB00001'
In the same way as...
March 18, 2013 at 6:16 am
I really liked it, so my second response !
Sergiy (3/17/2013)
Lynn Pettis (3/17/2013)
complex? I find them to make writing queries easier as you don't have to...
March 18, 2013 at 6:05 am
...
Derived table wins as it does not contain extra words ";WITH MyData AS ".
...
:w00t::w00t::w00t::w00t::w00t:
"extra words" is a greatest argument to declare a "code" winner I'have ever seen.
Extra typing always makes...
March 18, 2013 at 5:58 am
SELECT TransactionID, MIN(VoucherNo) , MAX(VoucherNo )
FROM yourtable
GROUP BY TransactionID
March 18, 2013 at 5:42 am
If you enable READ COMMITTED SNAPSHOT in the database, it becomes the default isolation level.
So, it can break some of your application functionality which would depend on default behavior under...
March 18, 2013 at 5:07 am
akberali67 (3/18/2013)
I have a query window with a lot of code but I do not want to run it entirely in error, is there something I can place in the...
March 18, 2013 at 3:24 am
... but I don't want to grant view server state permissions and all that it exposes...
What exactly are you afraid of? What dangerous things does it expose other than ability...
March 18, 2013 at 3:13 am
Viewing 15 posts - 556 through 570 (of 2,894 total)