Viewing 15 posts - 2,911 through 2,925 (of 3,348 total)
Paul White NZ (3/30/2010)
Hugo Kornelis (3/30/2010)
As far as I know, that was once the case. In SQL Server 7.0 or so.
It's still in Itzik's Inside SQL Server 2008 T-SQL Querying...
March 30, 2010 at 12:41 pm
Paul White NZ (3/30/2010)
Hugo Kornelis (1/27/2010)
the strangely popular but really rather odd EXISTS 1 instead of EXISTS *...
I too find it odd, and always use the star syntax, but it...
March 30, 2010 at 12:25 pm
Tom.Thomson (3/29/2010)
(...)then it copies all the database pages from disc to the backup media
As far as I know, the backup process copies pages from cache to the backup file, not...
March 30, 2010 at 12:54 am
Festeron (3/29/2010)
Tom.Thomson (3/20/2010)
vk-kirov (3/20/2010)
Tom.Thomson (3/19/2010)
But a single select statement may write more pages than can be held in RAM and this means that dirty pages get to disc
"Insert statement", I...
March 29, 2010 at 11:40 am
John Carlson-431129 (3/25/2010)
vk-kirov (3/25/2010)
Hugo Kornelis (3/25/2010)
' ' is converted to the value 0 (run [font="Courier New"]SELECT CAST(' ' AS int);[/font] if you don't believe me).
This is very interesting because [font="Courier...
March 25, 2010 at 3:09 pm
john.arnott (3/25/2010)
But, then again, the implicit conversion features let us create little gems like this:
Select 3*3e3+3e3/3ee3e,3e3e3e3eTry to parse that manually before you copy/paste to SSMS.
My eyes! The goggles do nothing!
March 25, 2010 at 3:07 pm
ziangij (3/24/2010)
thanks :-)... its a good interview question.
I would not be too happy with these things being asked in an interview. My answer would be that mixing data types like...
March 25, 2010 at 2:04 am
Good question, but unfortunately the explanation is not entirely correct. Especially this part is very misleading:
Also the preceding space is not considered while performing the operation.
Let's look in detail what...
March 25, 2010 at 2:01 am
vogelz (3/16/2010)
Whenever a full backup is initiated it will place a pointer in the transaction log in order to understand from where the...
March 16, 2010 at 5:57 am
Great question!
One additional comment that was missing from the question and description, is how pending transactions are handled.
IF the session inserting the 10000 rows does so within a transaction, and...
March 16, 2010 at 1:39 am
Steve Jones - Editor (3/10/2010)
sameerchachad 69959 (3/9/2010)
March 10, 2010 at 8:12 am
sameerchachad 69959 (3/9/2010)
Correct answer (SQL Server Central) : False
I would just like to add a small point, whenever you...
March 10, 2010 at 1:24 am
I know the question is quite a few days already, but I just HAVE to reply. Hoping that everyone who has enthused about this method in this thread is still...
February 26, 2010 at 1:22 pm
Paul White (2/4/2010)
On a slightly different note, have your considered extending you set-based iteration method to implement other analytic functions like LEAD, LAG, or SUM() OVER (x PRECEDING) for example?
No....
February 4, 2010 at 4:18 pm
Hi Paul,
Thanks for the clarification of your position. I'll clarify mine too.
I, too, have an enormous respect for Jeff. I always read his articles here with great interest and I...
February 4, 2010 at 2:09 pm
Viewing 15 posts - 2,911 through 2,925 (of 3,348 total)