Viewing 15 posts - 1,156 through 1,170 (of 1,479 total)
Actually as far as I know when you delete records even if the page is empty, it will still belong to the table. Truncate table will release the pages....
February 12, 2009 at 5:20 am
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...
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...
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...
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...
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...
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...
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...
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), '')...
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...
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...
February 8, 2009 at 5:34 am
Yep, that was wrong. Thank you for the correction.
Adi
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...
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...
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...
February 7, 2009 at 4:17 am
Viewing 15 posts - 1,156 through 1,170 (of 1,479 total)