2010-02-15 (first published: 2010-01-18)
20,867 reads
Scripts
Database Users And Associated Database Roles
This script basically retreives all database users thier database roles for a database.
2010-02-10 (first published: 2010-01-20)
3,447 reads
2010-02-08 (first published: 2010-01-13)
4,150 reads
2010-02-05 (first published: 2010-01-18)
1,047 reads
Script Table or View structure
This code will let you script a Table or Views structure for source control.
2010-02-02 (first published: 2010-01-12)
2,186 reads
Listing Subscribed SSRS Reports including Parameters & their Values
This script will allow user to analysis their Subscribed Reports.
2010-02-01 (first published: 2010-01-11)
2,137 reads
Object Search for Sql Server 2005
This script will search databases, tables, columns, stored procedures for text.
2010-01-28 (first published: 2008-12-21)
1,280 reads
Display Rows Vertically or Alphabetically
Display a row vertically when a table has hundreds of columns to avoid scrolling.
2010-01-21 (first published: 2009-12-30)
3,231 reads
datetime precision
Accuracy and precision go hand-in-hand. This script helps trim date values to whatever size is stored in a table's column.
2010-01-20 (first published: 2009-12-21)
1,443 reads
Implementing Most Recently Used Lookups
This script will adapt ordering of look-up lists by foreign key usage.
2010-01-18 (first published: 2009-12-23)
953 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
% processor Time in Activity monitor is greyed out
When I connect to my SQL Server using SQL Server Management Studio (SSMS) from...
Question of the Day
The Hash Join II
Which of these inputs is the smaller input to a hash join?
See possible answers