Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,885 reads
dump
RE: to improve performance?
SQL Profiler and the Index Tuning Wizard. With SQL Profiler, you can capture long running queries to concentrate on first, or you could do a general capture for feeding the Index Tuning Wizard.
2003-05-15
RE: changing dates on one instance/database
Not the best, but seems to be working. CREATE VIEW Test as Select DateAdd(hh,2,GetDate()) as TheDate GO CREATE FUNCTION TestDate() Returns @TheTable TABLE ([GETDATE] DateTime) as BEGIN Insert @TheTable Select TheDate From Test RETURN END GO CREATE FUNCTION TestDateII() Returns DateTime BEGIN RETURN (Select [GetDate] from dbo.TestDate()) END GO Select dbo.TestDateII() GO Suspect the overhead […]
2003-05-15
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