Viewing 15 posts - 1 through 15 (of 27 total)
Robert Cary (1/29/2011)
There is nothing humble about your opinion.
If you read his post, you will see he is correct and is actually taking the time to explain his answer...
January 29, 2011 at 2:13 pm
jinlye (1/29/2011)
Sorry but you seems to be new to English as well..
Sorry to do this, but I have to point out as an English speaker, that should be 'you seem',...
January 29, 2011 at 2:03 pm
jinlye (1/29/2011)
Subhash Kr Singh (1/28/2011)
UPDATE tablename SET name = 'test'Will it work?
...The straight answer to your question is yes...
PS Don't be put off asking because of earlier responses.
Dear Jinlye, you...
January 29, 2011 at 12:46 pm
Subhash Kr Singh (1/28/2011)
I am just new to sql server. But I just want to know one simple question what will be the statement if i want to update...
January 29, 2011 at 4:17 am
Perhaps this has been already said but in my opinion author makes VERY important FALSE assumption.
The condition @@ROWCOUNT < table/index/statistic COUNT has NOTHING in common with presence or not WHERE...
January 26, 2011 at 3:46 pm
"Symmetric algorithms require a single key for both encryption and decryption which allows for high-performance;"
I would say both facts (using single key for encrypting and decrypting data and algorithm speed)...
January 10, 2011 at 8:13 am
Hmm,
I might be wrong but OPENROWSET has nothing to do with special or elevated permissions on remote server, but it requires Ad Hoc Remote Queries to be allowed on local...
September 14, 2010 at 4:28 pm
Too lazy to google around ?
http://qa.sqlservercentral.com/articles/Administration/2960/
September 13, 2010 at 1:59 pm
perhaps OPENROWSET could help:
From Books Online:
SELECT a.*
FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',
'SELECT GroupName, Name, DepartmentID
FROM AdventureWorks.HumanResources.Department
ORDER...
September 13, 2010 at 9:01 am
Hi,
Ad 2:) It does. Inserts will be slower, but how much slower - I can't tell. Probably you will not even notice difference with single or dozens of inserts.
Ad...
September 13, 2010 at 2:33 am
It is all about statistics and index selectivity.
You issued:
SELECT * FROM table WHERE fname='???'
It means that for every row found in index sever must perform lookup to...
September 12, 2010 at 2:21 pm
Indexed column and string used in WHERE clause must use the same collation. Otherwise index will not be selected - server will do full scan and compare values row by...
September 11, 2010 at 2:35 pm
Multiple instances are used not for increase overall performance, but for increase manageability.
One instance or three all share the same physical resources.
In my opinion one instance is better from...
September 11, 2010 at 5:19 am
I wouldn't focus too much on database size, I would rather consider number of transactions and individual transaction size.
Splitting data into multiple volumes does make sense only if application can...
September 11, 2010 at 5:08 am
Viewing 15 posts - 1 through 15 (of 27 total)