Viewing 15 posts - 6,346 through 6,360 (of 7,168 total)
Basically this is how the CASE is executed by SQL Server...
SELECT CASE
WHEN (ABS(CAST(CAST(NEWID()...
May 24, 2011 at 2:17 pm
I just ran across a couple nice blog posts by one of our SSC cohorts on this very topic:
May 24, 2011 at 1:58 pm
amns (5/24/2011)
I've some tables with varchar data type in some columns.
This tables store static values, so i need to generate scripts for create table and table data.
I generate the scripts,...
May 24, 2011 at 1:25 pm
How can i capture the user name who used this sql account to connect to the sql server when they have to actually connect only using application, I would also...
May 24, 2011 at 12:33 pm
If I turn snapshot isolation on and find performance is adversely affected, do you think I can simply turn it back off to undo the damage?
You can turn it on...
May 24, 2011 at 12:25 pm
Please post your trigger code.
Do you have Database Mail ready and able to send emails from your database instance?
May 24, 2011 at 10:30 am
The best you can do is lookup the login's default database but there is no guarantee that the connection string did not provide an alternate/explicit database name to begin in.
I...
May 24, 2011 at 10:13 am
jcrawf02 (5/24/2011)
opc.three (5/24/2011)
May 24, 2011 at 9:30 am
Grant Fritchey (5/23/2011)
opc.three (5/23/2011)
Craig Farrell (5/23/2011)
GilaMonster (5/23/2011)
LutzM (5/23/2011)
GilaMonster (5/23/2011)
May 24, 2011 at 9:21 am
Not sure about "best practice", sounds like someone tossed in a buzz phrase to justify some action. Management is far enough away from the details to not know the particulars...
May 24, 2011 at 9:04 am
Because nolock has been deprecated, though, my bosses want me to use snapshot isolation instead.
The NOLOCK hint has not been deprecated on SELECT statements, only with the use of UPDATE...
May 24, 2011 at 7:38 am
Sure thing jcrawf02. As a side note, I would not have posted at all because the poster would have caught the IN/NOT IN logic nugget, however when there is a...
May 24, 2011 at 7:10 am
Duplicate post...direct replies to this post since OP confirmed they are on 2005:
http://www.sqlservercentral.com/Forums/Topic1113770-149-1.aspx
May 24, 2011 at 5:27 am
In the 2005 link Koen posted it says:
If the /ConfigFile option specifies a location for the configuration file that is different than the location that the package specifies, the dtexec...
May 24, 2011 at 5:22 am
Viewing 15 posts - 6,346 through 6,360 (of 7,168 total)