Viewing 15 posts - 16 through 30 (of 201 total)
peseta30 (1/17/2012)
AR_Amount = sum(isnull(Amount,0))
where 1 = 1
and Customer =...
January 18, 2012 at 12:03 am
I have never needed to store information about Timezones so excuse me if this is a stupid question. But wouldnt it be easier to store this in a separate column?...
January 9, 2012 at 11:33 pm
Going to stick my neck out and say that its wrong.
Yes the stream aggregate gets called first... but it hasnt finished. So is the important part which gets called...
October 27, 2011 at 12:28 am
xiewei (10/23/2011)
UPDATE table1 SET col1 = (select distinct case a.col1 when '1' then '0' else '1' end from table1 a where a.col1=table1.col1)The solution is very clever!
No its not. Its...
October 24, 2011 at 12:19 am
Joy Smith San (10/4/2011)
ExpertsI know that google is my friend...
But still, can anyone tell me how shrinking database adds fragmentation ?
Thanks in advance.
Smith.
http://www.sqlskills.com/BLOGS/PAUL/post/Why-you-should-not-shrink-your-data-files.aspx
/T
October 4, 2011 at 3:00 am
dgvozdetsky (10/3/2011)
Very interesting question 🙂In my case on SQL 2008 R2 i receive follow result:
- table variable - 29290 ms
- temp table - 240 ms
Cool. The comment block in the...
October 3, 2011 at 3:11 am
stewartc-708166 (10/3/2011)
Thanks
Something to bear in mind: There are numerous factors that influence the choice between table variables and/or temp tables, inter alia:
> Data set size (number of columns...
October 3, 2011 at 3:04 am
Carlo Romagnano (10/3/2011)
tommyh (10/3/2011)
The other being that the answer is wrong. They both perform equally....
October 3, 2011 at 2:51 am
There are several problems with this question. One being that you cant declare @Start 2 times.
The other being that the answer is wrong. They both perform equally. I have executed...
October 3, 2011 at 12:16 am
Ninja's_RGR'us (9/23/2011)
tommyh (9/23/2011)
Server: Msg 16915, Level 16, State 1, Line 1
A cursor with the name 'hCForEach' already exists.
messages when i run that code. Maybe its...
September 23, 2011 at 5:27 am
I get a bunch of
Server: Msg 16915, Level 16, State 1, Line 1
A cursor with the name 'hCForEach' already exists.
messages when i run that code. Maybe its a bug...
September 23, 2011 at 5:21 am
Create a table to store result
create table tempdb..TableRowCounts (db varchar(128), tablename varchar(128), RecCount int primary key (db, tablename))
Count rows in all usertables i all DBs and store in the table...
September 23, 2011 at 12:25 am
There is a "slight" difference between "pausing database mirroring" and "If the mirror is unavailable".
Better link ?
http://msdn.microsoft.com/en-us/library/ms190664.aspx
/T
September 20, 2011 at 11:29 pm
JOIN (SELECT StudentId as StudentNumber, max(RequestNbr) as RequestNb
FROM Request
...
...
September 19, 2011 at 12:32 am
christofer.jarlesjo (9/14/2011)
September 15, 2011 at 5:05 am
Viewing 15 posts - 16 through 30 (of 201 total)