Who did what?
This select will show the last sql statement for every open session plus many helpfull information.
2012-01-13 (first published: 2008-03-04)
4,055 reads
- Interests: MusiC (Heavy Metal), basket ball
2009-12-17 (first published: 2008-07-13)
1,810 reads
2009-04-17 (first published: 2008-10-15)
1,098 reads
2009-04-09 (first published: 2009-03-16)
1,343 reads
Get DBMail information
get the profile name and the account name etc about the dbmails created on the server
2008-09-12 (first published: 2008-07-13)
975 reads
2008-08-27
1,005 reads
2008-08-20 (first published: 2008-06-19)
1,113 reads
2008-06-20 (first published: 2008-05-11)
1,454 reads
Script permissions on all databases
i took the core from a script found in the site for generating permissions and update it.
2008-05-06 (first published: 2008-03-06)
3,492 reads
space check
When run it will check the space left on the disk. If it was under 4GB it will raiserror.
2008-05-05 (first published: 2008-03-04)
1,428 reads
Blogs
Storage Field Day 23 – HammerSpace
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
Daily Coping 16 May 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Saturday Jacksonville Slide Decks
By Steve Jones
Here are the slide decks for my sessions at SQL Saturday Jacksonville 2022 Continuous...
Forums
Options to access/modify cloud data?
Hi, Novice here, so please forgive my simple question. I have previously run Microsoft...
Row wise sum based on condition
Hi All, I have an input like below. mytable: id | name | no...
why execution plan high cost on clustered index scan and how to mimize cost of c
I work on sql server 2019 i have clustered index scan 98 percent how...
Ask SSC