[SQL Server 2008 issues] SQL Server Transactional Replication . Artice not created by snapshot |
- SQL Server Transactional Replication . Artice not created by snapshot
- Performance Improvement
- SQl Server R2 Enterprise Evaluation link anyone?
- SQL Server Startup Options
- SSIS - Component which will pass the data to dataset or inline memory location
- Column update
| SQL Server Transactional Replication . Artice not created by snapshot Posted: 09 Jun 2013 04:55 PM PDT Good Day,We are running SQL Server 2008r2 using Transactional Replication. We selected a numbe of tables to replicate . One of them however is not created by the Snapshot although it is one of the selected articles. The object owner was not changed and I confirmed that it was selected, but when I tried to select it on the subscriber , the article does not exist. I also confirmed other tables were populated . What else should I be looking for ? |
| Posted: 09 Jun 2013 03:59 PM PDT Hi, I have a small query - by changing the datatypes in a table, will it improve the performance. For example, in one of the db I had identified the column SexCode defined as Varchar(1), where as it can be defined as Char(1). By doing so, am going to save the extra 2 bytes Varchar consumes, and the value stored in the column is either - M/F. Also, the table is filled with data. Need suggestions. |
| SQl Server R2 Enterprise Evaluation link anyone? Posted: 08 Jun 2013 09:14 PM PDT Hi,Anyone got a link or is hosting the older 2008 R2 enterprise evaluation version, I need to load up an emergency test environment, only seem to be able to get 2012 from MS links.Found this: http://download.microsoft.com/download/D/0/B/D0B2C565-4966-4663-976D-CAE8262F1844/SQLFULL_X64_ENU.EXE but it is not the R2 version , just the standard 2008, I need the same file but for R2.ThanksMatt |
| Posted: 09 Jun 2013 04:46 AM PDT Hi All, Can anyone tell me what the -F startup option does? I can't seem to find anything online for this :SCheers, |
| SSIS - Component which will pass the data to dataset or inline memory location Posted: 09 Jun 2013 01:07 AM PDT Which Component which will pass the data to dataset or inline memory location ?a) Sourceb) Destinationc) Pathd) Transformation |
| Posted: 08 Jun 2013 09:10 PM PDT this is my select query[size="1"]selectCalDate,Timein,Timeout ,CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108) AS SpendTime_runtime,CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) / 60 as varchar ) + ':' +-- Hours ( + ':' separator )CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) % 60 as varchar ) as excesstime_runtime,CASE WHEN DATEDIFF(MINUTE, t.[Timein], t.[Timeout]) >= t4.minute and t.[Timein] = t.[Timein] and t.[Timeout] = t.[Timeout] THEN 'Excess' else 'Short'END as [b]Excess,[/b]from#attendance[/size]i want to update excess column written in select query[size="1"]update#attendancesetexcessshort =CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) / 60 as varchar ) + ':' +-- Hours ( + ':' separator )CAST (ABS( 540 - DATEDIFF (MINUTE, Timein, timeout ) ) % 60 as varchar )-- Minutes,-- Only here so visibleSpend =CONVERT(varchar(8),DATEADD(ss,DATEDIFF(ss,[Timein],[Timeout]),0),108)from#attendance[/size]please suggest me a syntax Thank you for the help |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment