[Articles] Sensors and Data |
| Posted: 16 Sep 2013 11:00 PM PDT In the future we'll have a more programmable world, but it will be driven more by data than software. |
| You are subscribed to email updates from SQLServerCentral.com Articles tagged Editorial To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
[SQL 2012] Since Text and NText are being deprecated, what is the best data type to use for a Full text Index ? |
| Since Text and NText are being deprecated, what is the best data type to use for a Full text Index ? Posted: 17 Sep 2013 03:14 AM PDT I know varchar and nvarchar are the obvious ones, but i have noticed some developers using Varbinary and XML.Would there be any advantages in using Varbinary or XML?Thanks |
| Sql 2012 AlwaysOn Backups on All Servers? Posted: 17 Sep 2013 03:05 AM PDT I'm setting up a VM development environment and was wondering if it's possible with Sql 2012 AlwaysOn to get backups on all the servers in the availability group. I understand the point of offloading backups to your secondary machine is so your primary doesn't have to dedicate resources to backup jobs but we don't do a lot of work overnight so it's not a problem to take full backups on the primary in the middle of the night. We take tlog backups throughout the day. So, wouldn't it be better to take backups on the primary and secondary in case the primary server dies? I've played with the settings in the Back Up Database Task in Maintenance Plans and can't find a good way to have both the primary and secondary replicas take a backup, regardless of which is primary and which is secondary.Am I missing some easy way to do this? Thanks in advance for your opinions or suggestions.Tim |
| Microsoft's Data Virtualization Strategy Posted: 16 Sep 2013 05:26 AM PDT It seems to me that SSAS tabular models have some similar features when compared to data virtualization software, but the following cites "the combination of BizTalk, SQL Server Integration Services, Visual Studio, and SQL Server " as a Data Virtualization equivalent Microsoft.Where do we go if we want the true Data Virtualization features? ....outside of Microsoft?http://hendriekusr.wordpress.com/2012/10/10/data-virtualization/..excerpt from the above:VendorsThe Forrester wave, lists the following vendors, in their respective rankings:1. Informatica2. IBM3. Composite Software4. Denodo Technologies5. SAP6. Microsoft7. Stone Bond Technologies8. Red Hat9. OracleIt is clear that Informatica leads the pack, from a pure product perspective, by having Distributed Access, Data Services Implementation, Data Services Quality and Transformation, obtain a very high score.It is slightly mind-boggling why Microsoft has achieved such a high-ranking in this space. They provide BizTalk, SQL Server Integration Services, and Visual Studio as their Data Virtualisation tool set. Forresters comment on it as follows: "Although Microsoft does not actively market a productized data virtualization solution, customers often find that the combination of BizTalk, SQL Server Integration Services, Visual Studio, and SQL Server delivers a powerful option to create a data services layer, especially when using the Microsoft platform." |
| Posted: 17 Sep 2013 02:32 AM PDT I have a small db at my client site (SS2012,MS Server 2008) with an Access front end. It does some importing through Access (imports Excel workbooks created by the corporate server....) These are necessarily big, and they are replaced into a table on each import because the corporate server doesn't provide a key column. No big deal, I work through it, but I can't quite figure out why my log file is so big....On Mondays, the log file should get big, because all the imports are run on Mondays. But then, every morning at 3 AM, I have a backup sequence that backs up the entire instance, then (I thought...) truncates the log files. Yet, here it is Tuesday and the log files are huge (twice the size of the db....) My best guess is that I never truncate the space occupied by the logs, just delete the logs themselves.... I guess that's OK, but it seams like a lot of wasted space....Log file...6330 MB, DB file...3682 MBBackiup script (SQL Server Agent Job...)[url]https://picasaweb.google.com/lh/photo/2rlN0nnxNR-sWWefPJZkudMTjNZETYmyPJy0liipFm0?feat=directlink[/url] |
| Posted: 16 Sep 2013 09:44 PM PDT Hi AllCan someone perhaps put this in an example query please?exclude all "BA" items except BA00044Many thanks |
| Posted: 16 Sep 2013 07:09 AM PDT Hi I have designed a basic report in SSRS and was able to see the report data in the preview section and I did check the reporting URL in diff browsers.But when I try to deploy the project it's throwing an error - The specified report server URL could not be found.verify the syntax of the url and report server exists.Any ideas?Thanks. |
| Posted: 16 Sep 2013 07:43 AM PDT In the SQL command what is the correct syntax for creating a schema....I have tried both double and single quotes in the authorization owner_name but continually getting message saying user does not exist |
| At what point do stoplists actually start improving performance ? Posted: 16 Sep 2013 05:33 AM PDT I have two exactly the same tables with 4.5 Million resumes indexed with FTI, and a clustered unique ID.One table has the standard Microsoft 154 English stopwords.The other table has 10000 stopwords.Prior to running each query, i ran anUPDATE STATISTICS Tablename WITH FULLSCAN Then i ran a DBCC Freeproccache.Then i ran the following query:set statistics time on --select count(*) from Profiles91313bb select count(*) from Profiles where contains(doccontent, 'resume')and the results are basically identical, around 1.05 seconds.Is this because 4.5 Million records, with up to 10000 stoplist words per resume, is just not enough data to cause index bloat ?Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2012 / SQL 2012 - General To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
[T-SQL] UTC Conversion problem |
| Posted: 16 Sep 2013 06:58 AM PDT Have this query that if you run it past the 16 hour it throughs this error....I"m stumped?? If you run it as is runs fine, but if you try to designate a specific hour bombs out. What am I missing??ALTER PROCEDURE **** ( @Hour INT = NULL , @Application VARCHAR(30) = 'Shamoo' )AS DECLARE @UTCDiff INT , @Start DATETIME , @End DATETIME IF @Hour IS NULL SELECT @Hour = DATEPART(hh, GETDATE()) - 1--SET @Hour = '11' -- (INT Value. Ex: "11" for 11 o'clock of current day hour)--SET @Application = '' -- CHOOSE FROM :-- COCO-- MMS-- PAS-- SHAMOO-- TOOLS-- UBERMAIL SELECT @UTCDiff = DATEDIFF(HOUR, SYSUTCDATETIME (), GETDATE()) * -1 SELECT @Start = CONVERT(NVARCHAR(50), DATEPART(MONTH, SYSUTCDATETIME ())) + '/' + CONVERT(NVARCHAR(50), DATEPART(DAY, SYSUTCDATETIME ())) + '/' + CONVERT(NVARCHAR(50), DATEPART(YEAR, SYSUTCDATETIME ())) + ' ' + CONVERT(NVARCHAR(50), @Hour + @UTCDiff) + ':00:00' SELECT @End = CONVERT(NVARCHAR(50), DATEPART(MONTH, SYSUTCDATETIME ())) + '/' + CONVERT(NVARCHAR(50), DATEPART(DAY, SYSUTCDATETIME ())) + '/' + CONVERT(NVARCHAR(50), DATEPART(YEAR, SYSUTCDATETIME ())) + ' ' + CONVERT(NVARCHAR(50), @Hour + @UTCDiff) + ':59:59'-- SiteCatalyst Errors IF @Application = '' BEGIN SELECT [MESSAGE] , url , Cnt = COUNT(*) , MinTimeUTC = MIN(TimeUtc) , MaxTimeUTC = MAX(TimeUtc) FROM weblogging.dbo.elmah_error WITH ( NOLOCK ) WHERE APPLICATION = 'SHAMOO' AND timeutc BETWEEN @Start AND @End AND MESSAGE != 'Invalid viewstate.' -- Excluded in SiteCatalyst alerts GROUP BY [message] , url ORDER BY cnt DESC , MESSAGE END ELSE BEGIN SELECT [MESSAGE] , url , Cnt = COUNT(*) , MinTimeUTC = MIN(TimeUtc) , MaxTimeUTC = MAX(TimeUtc) FROM weblogging.dbo.elmah_error WITH ( NOLOCK ) WHERE APPLICATION = @Application AND timeutc BETWEEN @Start AND @End AND MESSAGE != 'Invalid viewstate.' -- Excluded in SiteCatalyst alerts GROUP BY [message] , url ORDER BY cnt DESC , MESSAGE END |
| Posted: 16 Sep 2013 06:14 AM PDT Hi guys,Can i load a cursor from a procedure?Like DECLARE cursor_importedPatients CURSOR FOR EXEC procedureThanks! |
| How do I remove the Nulls in my output? Posted: 16 Sep 2013 01:32 PM PDT CREATE TABLE #Total_Count (NUM_DEATHS_1870 numeric (8,0), NUM_DEATHS_1880 numeric(8,0)) INSERT INTO #Total_Count (NUM_DEATHS_1870)(SELECT COUNT (*) COD FROM [dbo].[1870_1880_DAT]WHERE YR_Died = '1870')INSERT INTO #Total_Count (NUM_DEATHS_1880)(SELECT COUNT (*) COD FROM [dbo].[1870_1880_DAT] WHERE YR_Died = 1880)MY OUTPUTNUM_DEATHS_1870 NUM_DEATHS_1880612 NULLNULL 720 |
| Advice on complex logic with embedded functions. Posted: 16 Sep 2013 09:22 AM PDT Hi,I have a scenario were under certain circumstances I need to use the earliest start date and then the latest finish date then work out days between these dates for records that need to be grouped together by a typeLatest finish date - earliest start date.In other circumstances, but using data from the same table I need to just use the start and finish date working out the days between without grouping by type.Finish date - start date.This determines the number of days another calculation needs to be greater than in order to qualify for my query. If the days between falls between certain ranges this gets me the days to be greater than called a qualifying period. The other calculation takes the start date, same as number 2 above and measures the days between.Actual finish - start dateI then check to see if this number of days is > the qualifying days.To determine if I should use just the start / finish date or the latest start / finish date I have a function that analysis about 10 parameters to work out what the rows type are first and then I can work out which method to use.All the information for parameters comes from three tables. All joined with inner joins.At the moment I feel I have functions embedded with functions and its not clean but messy.Just woundering how other people tacke complex scenarios like these. One option is I can pass in the rows unique id, have a select statement in a function get everything it needs and perform the calculation, but this feels I would be selecting from the same tables twice when I can use things like Max(date) over (Id) type logic.I could have a view with all the complex logic and self join using the Id mentioned above but this feels it would perfom not as well.Because the data is from 3rd party database, we cannot add indexes to improve performance or add application logic. I can select data only.Thank youEliza |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / T-SQL (SS2K8) To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
