SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.
2017-08-25 (first published: 2015-09-14)
25,747 reads
A script to create MERGE statements with data for specific tables.
2015-09-03 (first published: 2014-05-19)
5,211 reads
2011-12-19
2,155 reads
2011-04-25
3,067 reads
Wouldn't it be nice if you could have the report's name and filename be changed to something more specifically related to the particular run of that report.
2010-03-22
34,751 reads
Reporting Services has proven to be one of the more useful subsystems of SQL Server. However the standard editions of both SQL Server 2000 and SQL Server 2005 have limitations with regard to the subscription features. Jason Selberg brings us an updated version of his
code for extending the subscription feature.
2008-01-22 (first published: 2007-02-14)
28,099 reads
As many of you know, data driven subscriptions is not a feature available with SQL 2000 RS Standard Edition. However, you can accomplish this using the supplied stored procedure. It may not be as pretty as the version in SQL Enterprise, but this one gets the job done, and it is very ……useful!I have not […]
2006-11-13 (first published: 2006-05-11)
632 reads
Reporting Services is a great subsystem for SQL Server that fulfills quite a few needs. However just like SQL Server, there are some features that are limited to the Enterprise Editions, something that not every user can afford to implement. New author Jason Selburg brings us a way to implement subscriptions to reports using Standard edition.
2006-06-01
25,743 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers