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
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
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
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
How could I copy several tables from one owner to other in the same database ????? I have a database with around 150 tables with constraints checking several relationships, indexes, etc. (but without store procedures) I want to copy all of them to other owner (that I already have), in this case the destination owner […]
2004-05-11
1 reads
I have a case like this:table a - has one filed with statusIDtable b - has one filed with statusIDc - status code tbl - statusID(int,4), status Decription (char, 20)When I want to pull the description for the statuses I have in "a" and "b" for a particular custID (they will be always different) I could use:select * from a […]
2004-03-24
3 reads
HiFor my project i am trying to create an online registering system. The users enter all of the required info through the form it is then handled on the server by asp scripts.I have to tables resident and householdresident table:----------------------------------------Personal_ID (PK) | Name | DOB | Household_ID Household table:----------------------------------------Household_ID (PK) | Address | Post Code The problem i […]
2004-03-04
2 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers