Viewing 15 posts - 481 through 495 (of 1,048 total)
Hugo Kornelis (5/27/2013)
Mighty (5/27/2013)
One remark though:
...if you run code that generates an actual error
This not only works when an error has been generated. Any...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 27, 2013 at 3:44 am
Good question.
Easy one!! 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 26, 2013 at 11:50 pm
Easy basic one to start the week 🙂 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 19, 2013 at 11:23 pm
Lokesh Vij (5/15/2013)
I found Today's question relatively easier than yesterday. 🙂
true 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 15, 2013 at 1:06 am
Good question Hugo..
Specially the link of CASE won't always evaluate in order 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 15, 2013 at 1:06 am
Can you guys please provide some more details on it....
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 14, 2013 at 4:41 am
Good question Hugo 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 14, 2013 at 4:33 am
I solved it...
suggesting solution if someone else faced this issue:
Go the SQL server confiuration manager > select Ib built accounts > Local System
It works like a charm 🙂 :-):-D
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 11, 2013 at 2:20 am
But how can we stop the trigger from being runned when updation is performing on some another column of a table
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 10, 2013 at 6:55 pm
Danny Ocean (5/10/2013)
Good question, but Explanation is not completed or require more details.I think hugo can help us.
Right Vinay 😛
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 10, 2013 at 1:08 am
Mark-101232 (5/9/2013)
WITH CTE AS (
SELECT ID,VoucherNo,Status,VoucherType,
ROW_NUMBER() OVER(ORDER BY ID) AS rn1,
ROW_NUMBER() OVER(PARTITION BY Status ORDER BY...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 9, 2013 at 4:26 am
Thanks all for the suggestion 🙂
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 9, 2013 at 3:22 am
nenad-zivkovic (5/9/2013)
Toreador (5/9/2013)
If a column is referenced in a subquery that does not exist in the table referenced by the...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 9, 2013 at 3:18 am
IgorMi (5/9/2013)
What does its execution plan say? Are there any missing indexes? How big are the tables? Check the statistics on them.
You can replace the IN with EXISTS and NOT...
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 9, 2013 at 1:29 am
Try this--
ALTER DATABASE [DATABASE_NAME]
SET SINGLE_USER
WITH ROLLBACK IMMEDIATE
DROP LOGIN [Test2]
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 9, 2013 at 12:29 am
Viewing 15 posts - 481 through 495 (of 1,048 total)