Viewing 15 posts - 541 through 555 (of 1,478 total)
Notice that you are using 2 different data types in your query. In one of them you use ASCI character, and in the other one you are using Unicode....
--------------------------------------------------------------
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/
October 8, 2010 at 1:42 am
Why would you want to shrink all files on the server? Shrinking files is not a good habit:-). Shrinking the data files will cause fragmentation problems. Shrinking...
--------------------------------------------------------------
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/
October 8, 2010 at 1:20 am
Adiga (10/6/2010)
or some job is switching the RECOVERY model to SIMPLE and back to FULL?
Differential backup can work with all recovery models, so I don't think that switching recovery...
--------------------------------------------------------------
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/
October 7, 2010 at 1:46 am
I think that when it comes to clustered index, it treats the leaf level different then none leaf level. The leaf level’s space is considered as the data’s...
--------------------------------------------------------------
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/
October 6, 2010 at 11:41 am
Lowell (10/6/2010)
you'll need to put something in place to audit the tables or trace all sql statements.
For example if you create a server side DML trace ...
--------------------------------------------------------------
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/
October 6, 2010 at 11:07 am
I have to admit that I don’t agree with ALZDBA’s opinion. It is important to know and realize what clustered index does and how dropping it and\or creating 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/
September 28, 2010 at 1:36 am
If you think that the problem is that SQL Server is using to much memory and doesn’t leave enough memory to the OS, then you can limit the server’s memory...
--------------------------------------------------------------
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/
September 27, 2010 at 10:11 am
I don’t think that anyone here will be able to give you the solution. We don’t know how big the tables are, how many inserts you make, how many...
--------------------------------------------------------------
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/
September 27, 2010 at 1:55 am
Your post is not very clear. When you use keys to encrypt data, the data is stored as binary (or varbinary). If you don’t use any encryption at...
--------------------------------------------------------------
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/
September 22, 2010 at 5:47 am
When you execute a dynamic SQL, you need to use parentheses around the variable that stores the dynamic SQL. Also I don’t think that you need to specify 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/
September 22, 2010 at 5:30 am
You can use the undocumented procedure sp_MSforeachdb and query sys.objects in each database and check the create_date and modify_date columns. Here is an example (that I didn’t check, so...
--------------------------------------------------------------
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/
September 19, 2010 at 10:15 am
SQL Server 2005 or later supports try catch block. Before SQL Server 2005 the only way to have some kind of error handling was to check the value of...
--------------------------------------------------------------
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/
September 19, 2010 at 4:33 am
CirquedeSQLeil (9/15/2010)
Good question. I think it is worth noting that this behavior is exhibited because nested transactions do not truly exist in SQL Server.
It is worth mentioning that although...
--------------------------------------------------------------
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/
September 16, 2010 at 1:35 am
There is a very good reason that functions are not supposed to modify the data in the permanent tables. Let’s assume that for a minute that we could modify...
--------------------------------------------------------------
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/
September 15, 2010 at 4:23 am
This post shouldn’t be in the SQL Server 2000/7, because those versions don’t support Xquery. Having said that, the method query returns an untyped xml (just as you discovered)....
--------------------------------------------------------------
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/
September 9, 2010 at 1:59 am
Viewing 15 posts - 541 through 555 (of 1,478 total)