SQL Server - Global temporary tables
Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global...
2012-01-07
48,480 reads
[BUG] Inserts to tables with an index view can fail
Unfortunately some of the more troubling bugs can be very hard to reproduce succinctly. Here is one that has been...
2012-01-06
1,378 reads
What’s Wrong with this Picture: A Database Misconfiguration Well Demonstrated
Recently, I was doing some testing/playing around on a particular database on my home test servers. After I was done,...
2012-01-06
810 reads
Creating Strong Passwords
I was writing a presentation recently on encryption and one of the important things to show in the presentation is...
2012-01-06
1,074 reads
Normalizing Your Database
If you’ve been working with databases for any length of time, you have heard the term normalization.
Normalization is the process...
2012-01-11 (first published: 2012-01-06)
5,086 reads
Re-blog – December 30 – January 5
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-06
778 reads
Database uplevel Restores
Today I've been reading Paul Randal's collection of Blogs from a series called A SQL Server DBA myth a day....
2012-01-06
690 reads
Are you allowed to use social networking at Work?
I was reading this article about internet usage by staff who work for local authorities in Wales http://www.bbc.co.uk/news/uk-wales-16394916 The content...
2012-01-06
961 reads
Arithmetic overflow error and isdate sql
Executing a t-sql statement with a convert function
convert(datetime, my_date_column) ,
threw an arithmetical overflow error with the message :
Message
Arithmetic overflow...
2012-01-06
1,259 reads
A Tale of Two Cities - SQLSaturday Goes Global..
It was a day of warm weather, it was a day of cold weather. A tale of two cities on...
2012-01-06
2,059 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers