Viewing 15 posts - 1,036 through 1,050 (of 1,478 total)
SQL Server doesn’t keep this kind of information. If you need to know when data in table was modified, you’ll need to create you own mechanism. You can...
--------------------------------------------------------------
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 10, 2009 at 12:03 am
You can use NULL as default value for all parameters and then use case in the update statement. Your set clause should look like this:
…SET suppid = CASE WHEN...
--------------------------------------------------------------
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 7, 2009 at 8:25 am
I once started working in a place and also noticed that there are few indexes that had the same structure but different names. I’ve made the mistake of deleting...
--------------------------------------------------------------
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 7, 2009 at 8:11 am
Not sure that I understand the way that you want the join, because the description that you wrote doesn’t match the results that you showed (or at least it didn’t...
--------------------------------------------------------------
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 6, 2009 at 8:12 am
If by unused you mean that no one activates the procedures and no one runs any DML statements on the tables (including select statements), then the impact would be very...
--------------------------------------------------------------
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 6, 2009 at 6:26 am
Have to admit that I started thinking that something is wrong with my email:-P
--------------------------------------------------------------
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 5, 2009 at 10:30 pm
Yes you can. I've done it few times and there is no problem.
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 3, 2009 at 5:04 am
You can check for this kind of format. Take a look at the script bellow that shows you how to check for format. I think that it 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/
April 2, 2009 at 7:06 am
I wouldn’t recreate the views. If you recreate the views in the wrong order, you’ll have the same problem again (e.g. if view B is based on view 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/
April 2, 2009 at 6:53 am
Chirag (4/2/2009)
Great explanation Adi.
Thank you. Nice to get a good feedback sometimes:-)
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 2, 2009 at 6:30 am
Your join is fine. This is the way that auto mode works. If you’ll look closely at your XML, you’ll see that there is a hierarchy in it....
--------------------------------------------------------------
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 2, 2009 at 5:21 am
About 13 years ago the internet was not as developed as it is today, and there were a lot of myths about it. I remember getting an email saying...
--------------------------------------------------------------
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 1, 2009 at 7:50 am
Your procedure has no transaction at all, so there could be cases where only part of the procedure will be committed.
If the procedure will encounter 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/
April 1, 2009 at 4:25 am
kinnon_2000 (3/31/2009)
sorry, having a bad day. didnt think it posted first time. delete isnt working for me so cant remove duplicate. :crazy:
If I now understand you correctly, you just want...
--------------------------------------------------------------
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 31, 2009 at 6:21 am
I’m sorry, but I still have few questions. The main question is how do you decide about the order. If I was in one group and moved 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/
March 31, 2009 at 5:10 am
Viewing 15 posts - 1,036 through 1,050 (of 1,478 total)