Viewing 15 posts - 316 through 330 (of 1,479 total)
SQL Server doesn't manage remote dependencies.
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/
June 26, 2012 at 1:59 am
Cursors have bad reputation, but in my opinion it is more because they are being used where they shouldn't be used. There were many cases in the past 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/
June 26, 2012 at 1:52 am
Actually you can define a different file group for BLOBS when you create the table. Take a look at CREATE TABLE statement and check the meaning of TEXTIMAGE_ON. ...
--------------------------------------------------------------
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 25, 2012 at 7:16 am
Here is one more way:
;with MyCTE as (
select HotelId, RoomTypeId, cast (DateKey as char(8)) as DateKey, FreeCount,
row_number() over (partition by RoomTypeId, case when FreeCount = 0 then 0 else 1...
--------------------------------------------------------------
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 25, 2012 at 6:27 am
When you build replication, the server creates stored procedures at the target database. The procedures have name that looks like this sp_MSoooXXXX. The ooo is replaced by...
--------------------------------------------------------------
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 25, 2012 at 4:18 am
One more option that might be good for you is to use the compute clause. This will create 2 separate sets of data (one with the real data and...
--------------------------------------------------------------
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 19, 2012 at 2:34 am
Obviesly as you wrote it would be much better to use an XML column and not store the XML as string. Having said that, depending on your text in...
--------------------------------------------------------------
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 19, 2012 at 2:06 am
If I understood you correctly you need to create an identity column for the ID and the date column can get the value of getdate() when you insert a record,...
--------------------------------------------------------------
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 18, 2012 at 10:06 am
Any character is greater then an empty string. Most chances are that the developer that wrote this statement wanted to get back all the values that that don't 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/
June 18, 2012 at 9:46 am
Most chances are that you have 2 strings that look the same, but there are some characters that can't be seen. Take for example this code
declare @tbl table (vc...
--------------------------------------------------------------
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/
May 30, 2012 at 9:44 am
asm1212 (5/30/2012)
So there is not a way to disable that so when you insert a record, it goes in as a regular number? So what happens...
--------------------------------------------------------------
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/
May 30, 2012 at 9:35 am
I'm sorry but I don't understand what you need nor how your data looks like. Pleas write a small script that creates the tables, insert few rows into 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/
May 30, 2012 at 2:54 am
SQL Server has build in error messages, that are stored in sys.messages table. A DBA can add more messages to this table using the procedure sp_addmessage. If...
--------------------------------------------------------------
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/
May 29, 2012 at 6:41 am
I'm sorry, but I don't see any errors. What I see is a code that checks if an error exists. If it does exist it drops the error...
--------------------------------------------------------------
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/
May 29, 2012 at 5:48 am
Are you sure that there are clients that don't use the Anonymous login?
You didn't write anything about how you insert the data. If you insert 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/
May 23, 2012 at 8:32 am
Viewing 15 posts - 316 through 330 (of 1,479 total)