Viewing 15 posts - 241 through 255 (of 2,647 total)
dan-572483 (8/27/2012)
1) Change the subscriber to Simplle Recovery
2) Full Backup
3) Shrinkfile command.
The Publisher DB already has daily full backups and transaction log backups...
Jared
CE - Microsoft
August 27, 2012 at 2:19 pm
dan-572483 (8/27/2012)
The log file in a subscriber database is nearly twice the size...
Jared
CE - Microsoft
August 27, 2012 at 1:39 pm
chandan_jha18 (8/27/2012)
Can you please use T-SQL commands to create subscription.Chandan
Although I prefer that myself, how does this help the issue? To the OP, is your distributor local to the...
Jared
CE - Microsoft
August 27, 2012 at 1:31 pm
saidapurs (8/22/2012)
Replication will happen on 2 major condition.
1. Table should be required a index (Cluster or non-cluster)
2....
Jared
CE - Microsoft
August 27, 2012 at 12:38 pm
viveksvkola (8/27/2012)
if i select parameter value as country name but report header show as country code in ssrs
Change the report header to use country name instead of country code.
Jared
CE - Microsoft
August 27, 2012 at 9:35 am
mailrahul.p (8/23/2012)
Its not actually a deadlock that is happening, but the processes(read/write)...
Jared
CE - Microsoft
August 23, 2012 at 3:18 pm
mailrahul.p (8/23/2012)
I am newbie when it comes to SQL server. I am currently working on SQL server 2008 and would like to a know few details about it.
In our...
Jared
CE - Microsoft
August 23, 2012 at 3:05 pm
vamshikris422 (8/23/2012)
I meant that the function is declared with 28 buckets of time each worth a week. We need that to be a rolling window which...
Jared
CE - Microsoft
August 23, 2012 at 1:42 pm
vamshikris422 (8/23/2012)
I have a SQL Server 2008 table which is partitioned into 28 weekly buckets based on a field timestamp.
Reason being, the table contains humongous data and we archive data...
Jared
CE - Microsoft
August 23, 2012 at 12:56 pm
If the values are already in a table, why are you passing them to a stored proc. Why not just reference the table in the proc? This would save...
Jared
CE - Microsoft
August 23, 2012 at 12:49 pm
DatabaseName and ServerName are options in profiler. Make sure you check the box to display all columns.
Jared
CE - Microsoft
August 22, 2012 at 12:07 pm
vp7986 (8/22/2012)
Min and Max doesn work for the 2nd Example.
Well, that's a collation issue. The default collation is case-insensitive, so BCD = bCd = BcD = Bcd... You can...
Jared
CE - Microsoft
August 22, 2012 at 12:00 pm
in my opinion if imp in ent mngr and physically click generate query exec plan it should damn well generate the plan. not pull the cached plan if it exists.
You...
Jared
CE - Microsoft
August 22, 2012 at 8:47 am
Also, google Gaps and Islands. Here is a link to a sample chapter in an amazing book that illustrates the problem and solutions. I suggest that if this sample...
Jared
CE - Microsoft
August 21, 2012 at 2:39 pm
Lowell (8/21/2012)
SQLKnowItAll (8/21/2012)
Lowell (8/21/2012)
SQLKnowItAll (8/21/2012)
Lowell, why the WHILE 0=0?thanks for catching that!
it was a copy paste blunder form something i adapted; i edited my post to yank that out;
Darn, I...
Jared
CE - Microsoft
August 21, 2012 at 2:06 pm
Viewing 15 posts - 241 through 255 (of 2,647 total)