Viewing 15 posts - 691 through 705 (of 1,158 total)
Personally, I like to have it enabled as I've previously been stung in the past
January 3, 2012 at 5:42 am
Jeff Moden (1/3/2012)
January 3, 2012 at 5:07 am
arr.nagaraj (1/2/2012)
* Dedicated IP address or SQL
* Dedicated ip address for msdtc
* Dedicated Virtual Name for SQL instance
* Dedicated Shared disks for Data and root directories
* Dedicated shared...
January 3, 2012 at 2:49 am
Depends on the size of the development team. From experience, you need one dedicated for every 6-10 developers depending on how much they rely on SQL. If the...
January 3, 2012 at 2:14 am
SQLKnowItAll (12/22/2011)
In my case I also have 2 post-graduate degrees, one of which pertains managing a business and understanding these types of things. Like a techy MBA 🙂
I on the...
December 22, 2011 at 11:56 am
is this a test question?
Its pretty basic T-SQL.
Do you want this persisted as data or a computed column? dynamic as TSQL or a View?
December 21, 2011 at 7:45 am
Koen Verbeeck (12/21/2011)
2) The GO statement is not really a TSQL statement. It is a batch seperator recognised by SSMS.http://msdn.microsoft.com/en-us/library/ms188037(v=sql.90).aspx
Its also useful as a quick and dirty way of repetition...
December 21, 2011 at 7:18 am
Dropping a #temp table will remove it from tempdb freeing up this disk space. Since the object has been dropped its allocated memory will become available for use again....
December 21, 2011 at 7:15 am
Chris Metzger (12/21/2011)
December 21, 2011 at 7:08 am
Obviously, insert your case sensitive character set as appropriate
select [COLUMN]
from dbo.
WHERE [COLUMN] like 'a%' COLLATE Latin1_General_CS_AS
December 21, 2011 at 4:52 am
I believe you will need to add COLLATE to your select statment with a case sensitive character set.
December 21, 2011 at 4:45 am
Colin Betteley (12/21/2011)
December 21, 2011 at 4:11 am
To follow up. The virtual machine CPU should be handled transparently to the OS. All of this is handled and emulated by VMWare.
December 21, 2011 at 4:08 am
There are currently 3 versions of the SQL binaries and there will be differences between each of these files. There versions will be the same but there will be...
December 21, 2011 at 4:07 am
Viewing 15 posts - 691 through 705 (of 1,158 total)