Viewing 15 posts - 571 through 585 (of 1,478 total)
touchmeknot (7/7/2010)
Adi, you are right, the records are filtered and I am updating...
--------------------------------------------------------------
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/
July 7, 2010 at 10:23 pm
You should take the recommendation under consideration, but don’t fallow them blindly. As stewartc Already mentioned, it shows the recommendation per query that was used on 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/
July 7, 2010 at 1:25 am
Truncate doesn’t activate delete trigger nor instead of delete trigger. Also unlike delete statement regular users don’t have permissions to truncate a table and can not be...
--------------------------------------------------------------
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/
July 7, 2010 at 1:15 am
Dates have many formats. There is a default format that is used on the server level, but this can be overwritten by login’s settings and session’s settings. Because...
--------------------------------------------------------------
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/
July 7, 2010 at 1:03 am
You have a join and a where clause. Most chances are that both (the join and where criteria) filter the records that should be effected from your update query.
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/
July 7, 2010 at 12:45 am
If a user belongs to both groups, he could do all DML statement on the table. When a user belongs to more then 1 group, he’ll get the...
--------------------------------------------------------------
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/
July 7, 2010 at 12:42 am
You can use the openxml function. Below is a code that works with some explanations, but I suggest that you’ll read about in BOL (Books On Line).
declare @xml varchar(500)
declare...
--------------------------------------------------------------
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/
July 1, 2010 at 11:08 am
You need to give more information and explain what you need to do. There are many ways to write a query in an XML document (for example open...
--------------------------------------------------------------
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/
July 1, 2010 at 7:23 am
I’m guessing that you meant that you want to get the query’s result as an XML document and not the query itself. If I’m correct, then you need 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/
July 1, 2010 at 6:09 am
You also have to grant him permissions to modify the schema that the table is build on (by using grant alter schema statement). The problem is that you...
--------------------------------------------------------------
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/
June 29, 2010 at 7:17 am
You can use a case statement inside sum function to check if you need to count a record according to the value in the flag column. Here is an...
--------------------------------------------------------------
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/
June 15, 2010 at 6:14 am
This can not be done this way. You can use dynamic SQL and then run the string that you created. Another way is to create a select query...
--------------------------------------------------------------
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/
June 15, 2010 at 4:34 am
You can find which table is referencing a specific table by running sp_help on the specific table. You’ll get lots of information about the table, and the last piece...
--------------------------------------------------------------
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/
June 15, 2010 at 4:27 am
imSQrLy (6/13/2010)
--------------------------------------------------------------
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/
June 14, 2010 at 1:39 am
You didn’t specify if you had any log backups during the time that you log was growing. If you had no log backups during that time, then 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/
June 13, 2010 at 1:20 am
Viewing 15 posts - 571 through 585 (of 1,478 total)