SQLSaturday Finally Has a Logo
Sometimes its the little things that seem to take forever! We've had a text only logo up for a while,...
2007-10-31
1,443 reads
SQLAndy
Nominations INETA North America Board of Directors
Picked this up from the local Net group here in Orlando. INETA is actually pretty helpful when it comes to...
2007-10-31
1,417 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-30
1,971 reads
How Much Pizza and Soda for a User Group Meeting (Why You Should RSVP)?
After a few meetings of oPASS this year the numbers I use are 2 slices of pizza and 2 drinks...
2007-10-29
1,454 reads
Views for Abstraction Posted on SSC
This went up today and there is one great comment about possibly using snapshot isolation as an alternative to the...
2007-10-25
1,365 reads
Steve Jones Finally Reads My Blog!
I've been following Steve's exploits trying to learn the podcasting business and we usually talk about it once a week...
2007-10-25
1,463 reads
SQLSaturday Finally Listed in PASS Connector
If you subscribe to the Connector (the main communication email from PASS.org) you should have gotten one yesterday that finally...
2007-10-25
1,400 reads
Untitled Pages in ASPX
If you do any coding in .Net using aspx pages you'll recognize this one. Each page has a title attribute...
2007-10-24
1,483 reads
Requiring Columns Over 900 Bytes to Be Unique
Had a friend call me recently to ask about how to do this, had an nvarchar(2000) column that needed to...
2007-10-22
1,457 reads
If Exists (Select 1...) vs If Exists (select * ...)
If exists is a well known way to improve performance because it returns as soon as it matches a single...
2007-10-21
1,840 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Getting Database MaiL Profiles
Comments posted to this topic are about the item Getting Database MaiL Profiles
Preserving Data
Comments posted to this topic are about the item Preserving Data
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers