Viewing 15 posts - 1,081 through 1,095 (of 1,478 total)
You cannot compare null with the an equal sign (=). When you check for null you have to use the is null or is not null operators. Take...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 18, 2009 at 2:28 am
Krishna (3/17/2009)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 17, 2009 at 7:00 am
Here is one way of doing so:
select noo, namee, min(SourceName)
from (
select distinct noo, namee, 'a' as SourceName
from samm
union
select distinct noo, namee, 'b'
from sammM) dt
group by noo, namee
I...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 17, 2009 at 6:51 am
AshaRRichardson2nd (3/16/2009)
this should actually be an add column datetime with a defaulte setting of getdate().Also, how do I specify no check constraint?
If you want to add a new column with...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 11:31 pm
After your last message, I looked for more information instead of using my memory, and I have to say, that you might be correct. When windows 2000 is used,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 9:02 am
I think that I understand you now. Instead of using one update statement that updates all the records, you are looping through the records and updating each record with...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 8:12 am
parth83.rawal (3/16/2009)
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 7:43 am
If I understand you correctly, both instances are not configured to use awe. If this is the case, none of them will be able to use more then 2GB....
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 7:33 am
Triggers don’t get fired for each record, they get fired for each statement. This means that if you ran one update statement, the trigger will be executed exactly one...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 7:13 am
If you are not using the 64 bit edition, you can’t use more the 2GB without configuring the server to use awe. If you are not using Enterprise edition,...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 16, 2009 at 6:08 am
If you don’t have a backup of this database, you can modify the files’ names, then create a new database with the same name and files’ structure as the old...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 15, 2009 at 9:32 am
You query the data the exact same way that you query a database that has only one MDF file. When you issue any SQL Statement you don’t have to...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 15, 2009 at 9:07 am
You can find an explanation here – http://msdn.microsoft.com/en-us/library/ms191516(SQL.90).aspx
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 15, 2009 at 9:01 am
The permissions that users have in the DB are stored in the user database and not on the server level. There is no need to script those permissions if...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 15, 2009 at 6:45 am
The error message is very descriptive – you are trying to convert a string to date but the value in the string can not be converted to date. One...
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 13, 2009 at 1:36 am
Viewing 15 posts - 1,081 through 1,095 (of 1,478 total)