2016-11-28 (first published: 2016-11-21)
2,979 reads
unused
Index Breakdown
Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.
2019-04-15 (first published: 2013-11-08)
6,978 reads
Find unused jobs
Job list cluttered?
This script will return a list of jobs that either have not run in X months or where the next schedule run date is older than today.
2013-07-24 (first published: 2013-06-25)
1,128 reads
2019-04-15 (first published: 2012-11-26)
3,260 reads
RE: SQL Server performance counters disappeared
We had to contact MS and they wound up coming on-site. There are app. multi different ways of performing this and they may not always work. In our shop they were able to fix 1 node and not the other
2004-12-03
RE: User permissions
Permissions are stored in the sysprotects system table in each database. The Action column defines what type of permission (SELECT/UPDATE/CREATE TABLE/etc) is being set. Read SQL BOL for more details about the columns, but basically you should be able to select from that table with a CASE statement to see what permissions are set.CREATE TABLE, […]
2004-09-06
RE: How can I parse comma delimited string into columns
Hi!Thank you for trying! But This isn't truly a comma delimited file (like a CSV). The number of commas varies for each row and there's that slash mark in there that indicates the logical end of the record (not the physical end), so using DTS or Bulk Insert isn't an option. I thought about that, […]
2004-09-05
The specified LSN for repldone log scan occurs before the current start of replication in the log
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2004-09-03
2004-09-02
RE: scope_identity
It sounds as if the actual generation of the Identity is not in the scope of the call to SQL Server. For example (since I know nothing of the structure of the interface) assume a call to a stored procedure that verifies data, then makes a call to a second SP to perform the actual […]
2004-05-11
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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