Viewing 15 posts - 76 through 90 (of 1,479 total)
It means that replication between Oracle and SQL Server will be deprecated. Replication between instances of SQL Server will not be deprecated.
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/
August 5, 2015 at 4:02 am
I don't have any exprience but this is take from BOL (https://msdn.microsoft.com/en-us/library/ms151149.aspx) "Heterogeneous replication to non-SQL Server subscribers is deprecated. Oracle Publishing is deprecated. To move data, create solutions using...
--------------------------------------------------------------
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/
August 5, 2015 at 3:37 am
Not very pretty, but it will work as long as you don't have any apostrophes in your string. There is a good chance that other inputs should also 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/
August 5, 2015 at 3:29 am
In your message you wrote that you are creating a new login but in the error message it seems that you are trying to add a user as a member...
--------------------------------------------------------------
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 22, 2015 at 4:09 am
If you can't have duplicate records, then here is another way:
declare @tt table
( TagId int, TagType int, ReportId int)
INSERT INTO @tt
...
--------------------------------------------------------------
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 15, 2015 at 2:00 am
You can also improve backup time by specifying in the backup statement the number of buffercount and maxtransfersize. Have a look at this article – http://www.sqlservercentral.com/blogs/dotnine-sql-server-and-more/2013/08/21/optimizing-sql-server-backup-and-restore/
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/
May 20, 2015 at 5:06 am
Delete doesn't cause page splits, so you don't have to worry about the delete statements regarding page splits. Inserts might cause page split. It depends on the value...
--------------------------------------------------------------
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 19, 2015 at 1:18 am
Raiserror can work with a string or an error number. If you use a string, the error number will be 50000. Here is a small example:
RAISERROR ('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/
May 19, 2015 at 1:05 am
If your server was installed as case sensitive, then you should use database master instead of Master.
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 28, 2015 at 3:19 am
No it won't. You'll have to rebuild it on your own.
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 28, 2015 at 3:14 am
Maybe I'm missing something, but you can set the deadlock priority in the procedure's code.
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 27, 2015 at 1:59 am
You can create a server group and then in one window in SSMS that is connected to the whole group run the script that creates or edits the procedures. ...
--------------------------------------------------------------
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 24, 2015 at 3:48 pm
I know that answering my own question is a bit strange, but I found out the problem and it might help someone else so I'm writing it as an answer...
--------------------------------------------------------------
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 6, 2015 at 7:23 am
When you rebuild a table, SQL Server modifies the value of column modify_date in sys.objects so it will have the value of the time that the table was rebuild. ...
--------------------------------------------------------------
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/
January 12, 2015 at 5:02 am
Can you try this version and see if this works for you?
SELECT w.ItemId
,w.DateID
,w.OpenningWareHouseUnits
,w.FcastSales
,w.GoodsIncoming
,w.TargetRunningStock
, SUM(TargetRunningStock) over (partition by ItemId order by DateID ROWS UNBOUNDED PRECEDING) as RunningTotal
FROM #WareHouseData w
ORDER...
--------------------------------------------------------------
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/
January 12, 2015 at 4:49 am
Viewing 15 posts - 76 through 90 (of 1,479 total)