Viewing 15 posts - 871 through 885 (of 1,478 total)
If you want that your code will continue to run in case of a runtime error instead of getting to the catch block, you’ll have to delete the catch...
--------------------------------------------------------------
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/
August 10, 2009 at 7:17 am
You can run the select statement bellow that will produce the alter table statements for you. Notice that this will do only part of the job. For example...
--------------------------------------------------------------
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/
August 10, 2009 at 7:12 am
I don’t think that you can use contains to get the same information that you got on your other query that used the like operator. The main problem is...
--------------------------------------------------------------
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/
August 10, 2009 at 6:28 am
This changes the picture completely:-). Express edition doesn’t have DTE as part of the installation. Unfortunately I don’t know about a free tool that does the same...
--------------------------------------------------------------
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/
August 10, 2009 at 2:19 am
The database engine tuning advisor is also called DTE and it is installed with the server. You can activate it from management studio. From the menu you have...
--------------------------------------------------------------
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/
August 10, 2009 at 1:10 am
Jeff Moden (8/9/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/
August 9, 2009 at 1:32 pm
How do you connect eventide to MeasuerID? Is it only by inserting order? Also how did you get the values for EventMeasureID?
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/
August 9, 2009 at 6:05 am
I’m sorry, but I can’t understand your request. Pleas take the time to read the article in my signature. The article explains how to post a question...
--------------------------------------------------------------
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/
August 9, 2009 at 5:24 am
You can do it with a comibnation of string functions such as charindex and reverse, but the question is why do you want to do it in the database? ...
--------------------------------------------------------------
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/
August 9, 2009 at 3:49 am
You can shrink the file by using the command DBCC shrinkdb or DBCC shrinkfile (You can read about it in BOL). You can also do it with the GUI...
--------------------------------------------------------------
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/
August 7, 2009 at 4:24 am
I didn’t know that I can get to an element that is not part of the XML that the nodes method produces. Although I’m not the original poster, this...
--------------------------------------------------------------
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/
August 7, 2009 at 2:53 am
If the table is a small table (less then 8 pages), then it is located on shared extent. Shared extent stores pages of few small tables that each 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/
August 7, 2009 at 1:46 am
It also depends on the place of living. For example in Israel there is a need to store Hebrew characters without using Unicode, so you can find servers 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/
August 6, 2009 at 7:03 am
As far as I know, there isn’t any DBCC REPAIR_ALLOW_DATA_LOSS command. The REPAIR_ALLOW_DATA_LOSS is one of the possible instructions to the server of what to do in case...
--------------------------------------------------------------
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/
August 6, 2009 at 4:01 am
You have to give the query a name and then create it as a view. For example suppose I have the fallowing query:
SELECT Name, ProductNumber, ListPrice AS...
--------------------------------------------------------------
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/
August 5, 2009 at 7:50 am
Viewing 15 posts - 871 through 885 (of 1,478 total)