Viewing 15 posts - 1,396 through 1,410 (of 2,894 total)
Mike John (6/27/2012)
Once committed it is committed....
Not for nested transactions, check this one:
begin transaction outerOne
update Table1 set Col1 = 'booo' where id =1
...
June 27, 2012 at 3:41 am
Don't be surprised if some databases, sometimes will be missed by sp_MsForEachDb...
June 25, 2012 at 10:42 am
zineb (6/23/2012)
Hi,I need your help on a similar case
...
Please open the new thread!
June 25, 2012 at 10:41 am
With over 500 points I guess you do know...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 25, 2012 at 10:39 am
There is another way with using quirky update instead of cte with two window functions.
select *, CAST(FreeCount AS BIT) avail, cast(null as int) grp
into #ba
from @booking b
order by Id
create unique...
June 25, 2012 at 5:27 am
Jizzy Wig (6/25/2012)
will this use the @@datefirst of the connection that inserts a record?
constraint DF_dbo_Table_Week default (datepart(week, sysdatetime()))
Just try yourself:
SET DATEFIRST 1
INSERT dbo.Table ...
SET DATEFIRST 7
INSERT dbo.Table ...
and...
June 25, 2012 at 4:46 am
If you: sp_helptext sp_msforeachdb and sp_helptext sp_MSforeach_worker, you will see when and why database can be missed out...
Both "foreach" undocumented procs are based on global cursors, therefore using them you...
June 25, 2012 at 4:26 am
Why not to use some of "Wingdings", it will add some security to your code.
Oops, it's not allowed... :hehe:
June 22, 2012 at 3:05 am
FunkyDexter (6/21/2012)
The point I was making making was that you couldn't do something like:-
Select * From...
June 22, 2012 at 3:02 am
adolf garlic-411709 (6/19/2012)
This is standard practice in date dimensions in a data warehouse, having a timekey of YYYYMMDD (int)
It is not!
This is not a STANDARD practice - it is...
June 21, 2012 at 8:41 am
That is bad one. Triangular-joins are performance killers in this case.
My advice is to read the article pointed in the first reply.
June 21, 2012 at 8:20 am
:setvar only works in SQL command mode.
I cannot understand why would you need dynamic sql for statements there.
Why not to have the same stored procedures in every database and call...
June 21, 2012 at 6:41 am
FunkyDexter (6/21/2012)
...
1. A exists doesn't work across a fixed list of values, only across a genuine sub query
...
Hmm, it depends what you call "a genuine" sub query (in...
June 21, 2012 at 6:25 am
Thomas Stringer (6/17/2012)
CELKO (6/17/2012)
Why use all this code to fake arrays or magnetic tapes? Just write five UPDATE STATISTICS commands and run the script.
The OP wants to update stats on...
June 18, 2012 at 6:56 am
You will need to start from here:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
June 18, 2012 at 6:49 am
Viewing 15 posts - 1,396 through 1,410 (of 2,894 total)