Viewing 15 posts - 1,156 through 1,170 (of 1,478 total)
I admit that I don’t know of a setting option that changes this behavior, but I would compare the setting options for both sessions and see if there is any...
--------------------------------------------------------------
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/
February 12, 2009 at 5:10 am
Regarding the second question – This is because of the way that XML works. In any XML document (regardless if it was created by SQL Server or by another...
--------------------------------------------------------------
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/
February 12, 2009 at 3:11 am
Upgrading 32 bit server to 64 bit server is not supported. You’ll need to install the 64 bit version and move the databases, logins, jobs, etc’ to the new...
--------------------------------------------------------------
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/
February 12, 2009 at 2:09 am
You can’t restore a database to an older version of SQL Server then the SQL Server that the database was backed up from. If you have a backup that...
--------------------------------------------------------------
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/
February 12, 2009 at 1:02 am
The question that you should first ask your self is if the file will get to its current size again. For example if you checked the amount of free...
--------------------------------------------------------------
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/
February 11, 2009 at 12:10 pm
GSquared (2/9/2009)
GilaMonster (2/9/2009)
Vijaya Kadiyala (2/9/2009)
What if the table already exists, so in this case we have to use Update Statement right!!
Why?
Alter Table Add .... and add the computed column...
--------------------------------------------------------------
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/
February 9, 2009 at 4:41 pm
GSquared (2/9/2009)
Vijaya Kadiyala (2/9/2009)
What if the table already exists, so in this case we 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/
February 9, 2009 at 1:31 pm
Sorry for the late response. You can use only one replace function and in that function replace char(13) + char(10) with an empty string:
SELECT replace(vc, char(13) + char(10), '')...
--------------------------------------------------------------
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/
February 9, 2009 at 1:13 pm
I’ve just checked it on my machine. It seems that if I modify the log file to have unrestricted growth, sp_helpdb does specify a limit, but it is a...
--------------------------------------------------------------
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/
February 8, 2009 at 7:23 am
You have a typo (maxsie instead of maxsize) but I suspect that you had this only when you wrote the alter table in your message and not in the code...
--------------------------------------------------------------
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/
February 8, 2009 at 5:34 am
Yep, that was wrong. Thank you for the correction.
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/
February 8, 2009 at 3:18 am
The logins aren't stored in the user's database. They are stored in the master database. The users databases store users that are mapped to the login. You'll...
--------------------------------------------------------------
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/
February 7, 2009 at 7:13 am
The best source for an answer to a question like this is Books On Lines. You can use the alter database statement to move files from one place 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/
February 7, 2009 at 4:30 am
You can use the queryout option in BCP which lets you export data according to a query instead of exporting a full table. In your query you 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/
February 7, 2009 at 4:17 am
Could be that the Severity level of the error that you are raising is to low (you can read about the serverity levels in books on line). ...
--------------------------------------------------------------
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/
February 5, 2009 at 1:54 am
Viewing 15 posts - 1,156 through 1,170 (of 1,478 total)