Viewing 15 posts - 586 through 600 (of 3,738 total)
I missed one.
Any input would be greatly appreciated?
For better, quicker answers on T-SQL questions, click on the following...
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, 2015 at 9:19 am
I had to stop the Snapshot Agent and Log Reader Agent.
For better, quicker answers on T-SQL questions, click on the following...
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, 2015 at 9:14 am
I have to synchronize the snapshot.
Microsoft says to do the following:
1.In Replication Monitor, expand a Publisher group in the left pane, expand a Publisher, and then click a publication.
2.Click the...
For better, quicker answers on T-SQL questions, click on the following...
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, 2015 at 6:24 am
I appears that all I have to do is remove the article and then generate snapshot?
For better, quicker answers on T-SQL questions, click on the following...
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, 2015 at 1:00 pm
The SPID's with a -1 have about 20 entries for the same DPID.
For better, quicker answers on T-SQL questions, click on the following...
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 24, 2015 at 4:50 pm
Thanks Jeff!:-)
For better, quicker answers on T-SQL questions, click on the following...
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 24, 2015 at 8:54 am
How do I counter the Trans Logging issue?
I know how to get around it.
If he tries to delete record for 16 years then he is going to have a problem.
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 7:29 pm
Jeff Moden (6/23/2015)
Welsh Corgi (6/23/2015)
Jeff Moden (6/23/2015)
Yep... Saw that. You'd be better off partitioning by year.
He wants to partition 15 years into the First Partition and the current year...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 7:23 pm
Jeff Moden (6/23/2015)
Welsh Corgi (6/23/2015)
Jeff Moden (6/23/2015)
Yep... Saw that. You'd be better off partitioning by year.
He wants to partition 15 years into the First Partition and the current year...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 6:56 pm
Jeff Moden (6/23/2015)
Yep... Saw that. You'd be better off partitioning by year.
He wants to partition 15 years into the First Partition and the current year in another partition
Then archive...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 5:44 pm
What factors should be considered in the Strategy?
He wants to put all but the last Year in a partition and then archive it.
There is a disk limitation with the Transaction...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 5:13 pm
Thanks!:-)
I did not get the example on the Date Ranges?
Did you see where I posted the records with GROUP BY Year and a record count for each year.
If I create...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 8:10 am
Welsh Corgi (6/22/2015)
Here is the data in that CreateDate Column:CreationDateYearRecordCount
NULL4439
19301
19401
19903
19975880
199863068
199985365
200082985
2001151719
2002255011
2003386974
2004408519
2005525129
2006638583
2007852965
20081262168
20092022856
20102974695
20113285952
20123631320
20134838442
20143982934
2015210
20162
20171
20181
20191
20204
20291
20311
20502
20771
20881
21022
21037
21042
21122
22011
23041
25552
29121
29131
30135
30141
30231
50081
50111
62011
70131
72011
82011
92011
They do not want it for performance reasons. They want it to be a way of archiving data.
With the Data being...
For better, quicker answers on T-SQL questions, click on the following...
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 23, 2015 at 5:44 am
Currently there are 3 File Groups. Primary, FG1 and FG2.
FG1 is the default.
What impact does have on creating file groups for the partition, if any?
For better, quicker answers on T-SQL questions, click on the following...
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 22, 2015 at 1:42 pm
Here is the data in that CreateDate Column:
CreationDateYearRecordCount
NULL4439
19301
19401
19903
19975880
199863068
199985365
200082985
2001151719
2002255011
2003386974
2004408519
2005525129
2006638583
2007852965
20081262168
20092022856
20102974695
20113285952
20123631320
20134838442
20143982934
2015210
20162
20171
20181
20191
20204
20291
20311
20502
20771
20881
21022
21037
21042
21122
22011
23041
25552
29121
29131
30135
30141
30231
50081
50111
62011
70131
72011
82011
92011
For better, quicker answers on T-SQL questions, click on the following...
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 22, 2015 at 1:11 pm
Viewing 15 posts - 586 through 600 (of 3,738 total)