Modifying and deleting extended properties
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,344 reads
Continuing the short series on extended properties, this article explains how to turbocharge the creation of extended properties
2011-03-29
11,344 reads
In this second article of a short series we look at using the Extended Properties which you have added to a database
2011-03-22
11,487 reads
When you are obliged to create a dimensional database for an SSAS cube, how can you do it as fast as possible?
2010-12-17 (first published: 2010-02-24)
16,918 reads
A cursor-free way of normalizing data from a denormalized data source into a database which uses "surrogate" IDs.
2010-01-25
5,518 reads
This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page
2009-09-16
9,101 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
38,415 reads
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
By Steve Jones
I leave tonight for Australia. I was in London 3 days ago, so this...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
I've tried different credentials, target server versions, etc. hitting our Primavera WSDL. Works great...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers