Sunday, May 26, 2013

[SQL Server 2008 issues] snapshot agent is not running

[SQL Server 2008 issues] snapshot agent is not running

snapshot agent is not running

Posted: 19 May 2013 04:41 AM PDT

Hi,Friends I am working on sql server 2008 r2 and I want to replicate data by using snapshot replication, when i create subscription and publication after being successful, my data didnot distributed to the table. when i check for problem, i found that my snapshot agent is not running on the subscription side, what should i do?

T-LOG ISSUE

Posted: 20 May 2013 07:04 PM PDT

Dear,Currently my t-log size is 3 GB and 87% is available free space. I take regular log backup and full backup in full recovery model.Now I wanna know that,1.If I delete log backup files after taking a full backup, would it create any problem while data recovery?2.If I wanna reduce the t-log size to 2 GB, what are the challenges in this decision?Please help me.Akbar

Decimal(18,0) or int?

Posted: 25 May 2013 12:45 AM PDT

Hi I have a column of data type decimal(18,0) can i change it to Int for the above case whether Performance improves if i changethanks with best regardsPradeep

Help with next date in SQL query

Posted: 17 May 2013 10:04 PM PDT

What I need is to be able to find out when a customer next called in from the date I have select with the next date & time on any Purchase, does don't need to be same. It's like using MIN & MAX but that does not work on this query as it select the same date & time for both.SELECT ID, Name, CallDateTime, Num, RCFROM HistoryWHERE (CallDateTime > CONVERT(DATETIME, '2013-05-01 00:00:00', 102)) AND (Outcome = 'Called')As you can see in the query above that all the data is in one overall table called History, this records all the purchases.So I want to know that if a customer after the 1/05/2013 called in with the outcome of called what was he next purchases date, some customer might not have come so that can stay blank. So the query is like this nowID Name CallDateTime Num RC3936803 Name1 01/05/2013 11:16:27 84 Called5211387 Name2 01/05/2013 12:14:21 604 Called5185689 Name3 01/05/2013 12:15:28 298 Called4811923 Name4 01/05/2013 12:29:36 170 Calledbut i also want it to show the below,ID Name CallDateTime Num RC Next CallDateTime Total Number Of Days3936803 Name1 01/05/2013 11:16 84 Called 04/05/2013 11:16 35211387 Name2 01/05/2013 12:14 604 Called 04/05/2013 12:14 35185689 Name3 01/05/2013 12:15 298 Called 04/05/2013 12:15 34811923 Name4 01/05/2013 12:29 170 Called 04/05/2013 12:29 3This is the query I have at the moment BUT not show how to add two more columns to it they are next called in date & time after the first called in. I want it to show the next time & date does not matter what the RC code is next visit.So I want mine output to show the below, adding the next called time & date and how many days it take from the first date to the next date,

Making data in a column unique (that's not a PK)

Posted: 20 May 2013 03:57 AM PDT

This may be an elementary question but if I don't ask, I won't learn.What's the best way to ensure that data entered into a certian column is unique and not already in the table even though the column is NOT the PK. For example:SalesmanIDSSNFirstNameLastName...etc...SalesmanID is the PK but I do want SSN to be unique as well. Is there something in the table design I can do to ensure this or do I need to resort to a Trigger or Stored Proc?Thanks in advance for offering help.

Count Words in Text Field and/or Column (frequency of use)

Posted: 03 Dec 2011 10:04 AM PST

I searched the archives for this and could not find a solution.I have a comment table and would like to get a word count.So for example, if comment #1 was red dress and comment #2 was purple dress, the result would be:1 red1 purple2 dressPerformance is not a concern. Thanks.
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog