Row Sampling Transformation and Percentage Sampling Transformation provide data sampling functionality. This functionality is useful in a number of Analysis Services and Data Mining-based scenarios.
Would any of you want to track your morale at work and have your boss access the data anonymously? Steve Jones think it's a good tool, but one that is easily abused.
This article describes the requirements to log ship databases between workgroup computers
The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.
Today we have a guest editorial from Andy Warren. Today Andy suggests you try some new tools and see if you can increase your productivity.
In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.
Today Steve Jones talks a little about the work environment for IT workers. We ought to pay attention and ensure we are taking care of ourselves.
Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
I have 13 restricted views in my EDW DB. 6 of them are created...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers