Viewing 15 posts - 91 through 105 (of 673 total)
Kevin Gill (10/19/2011)
SanDroid (10/19/2011)
Kevin Gill (10/19/2011)
October 19, 2011 at 9:42 am
Great question.
The obscure pieces of SQL data that I remember never stop ssurprising me. 😎
October 19, 2011 at 9:29 am
There are many compliance and policy laws in the US that govern the access and obfuscation of personal and/or financial data companies create and collect. This data usually could...
October 19, 2011 at 7:51 am
Kevin Gill (10/19/2011)
October 19, 2011 at 7:47 am
Thanks for the nice easy old school T-SQL question. Perfect for a Monday.
Check Constraints have worked like this for a while.
Always bee one of those things to remember or...
October 17, 2011 at 7:32 am
Nice Question.
Great example of how UNION, EXCEPT, and INTERSECT work together.
October 11, 2011 at 7:35 am
mtassin (10/5/2011)
October 5, 2011 at 1:19 pm
Nice question on Normalization. Would have been easier to answer if I knew that T was part of a database at BCNF or EKNF.
Thought I selected the right answers...
October 5, 2011 at 10:01 am
SQLRNNR (10/3/2011)
SanDroid (10/3/2011)
......Does anyone know what the difference would be between using a WITH statement and a TEMP table?
Do you mean as in using a CTE or subquery?
Sorry... I...
October 3, 2011 at 12:29 pm
Lynn Pettis (10/3/2011)
SanDroid (10/3/2011)
Not suprised it did not.
Becuase of this we always remove table variables from any code...
October 3, 2011 at 9:28 am
Nice question. I heard this was supposed to change in 2008.
Not suprised it did not.
Becuase of this we always remove table variables from any code we get.
Table Variables...
October 3, 2011 at 8:57 am
Great Friday question. One of the things I like about 2008 was that the latest version of Visual Studion matched the latest version of SQL server.
Can some confirm that...
September 30, 2011 at 9:23 am
Great question. More like this would be nice. 😎
I learned about this one before when someone asked me to help upgrade a SQL server from 6.5 to 7.0. Seems...
September 29, 2011 at 7:08 am
v_kozachuk (9/29/2011)
SQL Kiwi (9/29/2011)
v_kozachuk (9/29/2011)
But ,i think, the question must be more precise - "How many data filegroups are allowed for tempDB data"
The article on technet (http://technet.microsoft.com/en-us/library/cc966545.aspx)...
September 29, 2011 at 7:03 am
Great question rfr.
Been looking forward to it since you posted that you submitted a question.
I was not disapointed.
September 28, 2011 at 7:58 am
Viewing 15 posts - 91 through 105 (of 673 total)