Viewing 15 posts - 1,006 through 1,020 (of 1,478 total)
RBarryYoung (4/26/2009)
For anyone who has been wondering where I've been, let's jsut say that it has been an eventful two weeks. I am writing this now from...
--------------------------------------------------------------
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/
April 29, 2009 at 4:24 am
Here is another way to do it using replace and len functions:
Declare @t1 Table(mid int, val bigint)
Insert into @t1
Select 1,95 union all
Select 2,959 union all
...
--------------------------------------------------------------
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/
April 28, 2009 at 11:21 pm
Since we are sharing some bad code stories, I have to tell you the true and sad story from few years ago. At that time I was working 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/
April 23, 2009 at 3:47 pm
According to your trace’s definition, as soon as the file get to the size of 5MB, the trace will stop. Did you check if the file got to 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/
April 23, 2009 at 7:26 am
You didn’t specify what duplicate records are. I assume that when you say duplicate records you mean each record that has the same value in IDNO 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/
April 23, 2009 at 6:58 am
I don’t like this question and yesterday’s question. The fact that if we run the code it will have the same results as the answer that was selected 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/
April 23, 2009 at 2:46 am
Jack Corbett (4/21/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/
April 21, 2009 at 10:18 pm
Full text search uses a list of noise words. Noise words are words that most of the time we wouldn’t want them to be indexed because it will just...
--------------------------------------------------------------
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/
April 21, 2009 at 8:11 am
Can you explain why the SQL Statement has to use the exist operator?
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/
April 20, 2009 at 10:01 pm
I don’t think that writing SQL Code should be protected by copyright laws. There is a very big difference between writing a novel or creating a movie and writing...
--------------------------------------------------------------
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/
April 19, 2009 at 7:52 am
If I’m not mistaken, build 10.00.1075 is a CTP. Is there any reason that you still work with a CTP?
I’m not sure that this should...
--------------------------------------------------------------
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/
April 19, 2009 at 7:03 am
Distinct works on all the columns in the select clause. Most chances are that the column that you added has a unique constraint (or a primary key constraint)...
--------------------------------------------------------------
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/
April 19, 2009 at 2:10 am
Check the small demo bellow. I didn’t fallow the exact way that you asked, but if you want you can modify it to have also a delete statement before...
--------------------------------------------------------------
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/
April 17, 2009 at 1:22 pm
Just run a query on master.dbo.sysdatabases. You can sid column as an input to suser_sname function, and name and created date are already in table (crdate).
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/
April 16, 2009 at 9:05 am
Case statement is not a flow control statement. It is a function that returns a value. In your code you are using it as a control statement 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/
April 16, 2009 at 7:39 am
Viewing 15 posts - 1,006 through 1,020 (of 1,478 total)