Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
Can I create in T-SQL a stored procedure that loops through rows and concatenates data into a variable, as I do in Visual Basic (VB)?
There are two basic ways to solve problems in T-SQL: row-by-row processing or set-based logic. Row-by-r...
I created a unique constraint on a column called Col1 in table Test1 to enforce uniqueness with the exception of NULL. The entry for "Unique Constraint" in SQL Server Books Online (BOL) specifically says that you can create a unique constraint on...
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to [email protected]. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...
The only measures useful in some types of analysis are measures that are derived from multiple loaded measures (i.e., those from the fact table) or from some calculation that uses other dimensions. In such cases, you need to create a cube that has...