Viewing 15 posts - 631 through 645 (of 1,478 total)
If your column is a numeric column, then it should behave this way. If you need to store the leading zeros, then maybe you should work with strings instead...
--------------------------------------------------------------
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, 2010 at 9:26 am
I agree with Grant. Inserting million records one by one doesn’t sound at the correct way. If you don’t want to use SSIS, you can check out Bulk...
--------------------------------------------------------------
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 9, 2010 at 8:32 am
ramyours2003 (3/9/2010)
reboot the services , and observer the size
I’m sorry but this is not really a valid reason to reboot server. Also it is not guaranteed that the TempDB...
--------------------------------------------------------------
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 9, 2010 at 7:45 am
Are you sure that you should shrink the tempdb? If the databases reached its current size during normal work, then there is no need to shrink it because it grow...
--------------------------------------------------------------
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 9, 2010 at 7:42 am
Convert has a third parameter that is optional and is called style. It is mostly used with dates. For example check out the next script:
declare @dt char(10)
select @dt...
--------------------------------------------------------------
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 8, 2010 at 3:52 am
Just read my first post again. If you have any question about it, I’ll be glad to answer them.
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 4, 2010 at 1:05 am
I agree that with the assumptions that the table exists, it has at least 2 records and the code is ran on SQL Server 2005 or later, then the only...
--------------------------------------------------------------
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 3, 2010 at 11:07 pm
Saravanan T (3/3/2010)
My question is can i update the same table like below in another session....without commiting or rollbacking the session 1.
...
--------------------------------------------------------------
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 3, 2010 at 10:06 am
Could be few reasons. If your table has no index that it can use to locate the record, then it needs to do a table scan. In 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/
March 3, 2010 at 3:36 am
I wouldn’t say that using XML parameter should hurt performance. As in many other things, I would say that it depends. If XML parameter would be something 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/
March 3, 2010 at 3:25 am
I’m sorry but I don’t understand the question. Can you clarify it? What do you mean when you say that you have corrupted relations between the tables? ...
--------------------------------------------------------------
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 3, 2010 at 3:20 am
I agree with the posters that claim that the question had more then 1 answer that could be correct. I guessed the answer because I assumed that the table...
--------------------------------------------------------------
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 3, 2010 at 3:13 am
If you use a numeric data numeric data type (by numeric, I mean any data type that can only store numbers such as int, decimal, money etc’) then the server...
--------------------------------------------------------------
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 2, 2010 at 5:28 am
First I have to admit that I didn’t check the code, so there are maybe other issues that I didn’t notice. As for your question, you can use nested...
--------------------------------------------------------------
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 2, 2010 at 4:59 am
Why are you formatting the numbers in the database? The numbers should be formatted in the presentation layer.
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 2, 2010 at 4:43 am
Viewing 15 posts - 631 through 645 (of 1,478 total)