Tuesday, September 17, 2013

[SQL 2012] Since Text and NText are being deprecated, what is the best data type to use for a Full text Index ?

[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."

Why logs so big

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]

excluding a range in a query

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

Report deploying in ssrs

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.

Schemas

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
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog