2017-12-29 (first published: 2017-12-27)
1,444 reads
shrink
The Case of the Shrinking CFO, err Database
Shrink SQL Server databases quickly and with virtually no contention.
2017-12-25 (first published: 2015-08-17)
4,286 reads
2008-11-20 (first published: 2008-10-06)
958 reads
RE: Performance Tips Part 1
You can rename indexes and other objects:use pubsif object_ID('test_rename_HIS') is not null drop table test_rename_HIS if object_ID('test_rename_ARC') is not null drop table test_rename_ARCcreate table test_rename_HIS (ID int Not Null constraint PK_HIS Primary Key, Name varchar(255))go create index I_HIS on test_rename_HIS (Name)go exec sp_rename @objname = 'test_rename_HIS' , @newname = 'test_rename_ARC' , @objtype […]
2005-03-08
RE: Missing images from report
No ISAPI filters installed on the system, but thanks for the suggestion. It looks like it may be a permissions problem somewhere, but as I said you can render the report as a pdf or even a web archive and the images and charts appear correctly.Still confused!
2004-04-14
RE: How to get available SQL Server names?
This is you are looking for. http://support.microsoft.com/default.aspx?scid=kb;en-us;287737
2003-06-02
RE: Paasing Database Name to Stored Proc
Thanks for the tip, it worked fine. One other question, then. How and why do you use SYSNAME in sprocs? Thanks
2003-05-29
1 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers