What is mssqlsystemresource?
If you are lucky you’ve never seen an error along the lines of:
The SELECT permission was denied on the object...
2013-03-04
987 reads
Kenneth Fisher
Insert multiple values sets into a table in one command
The INSERT command has two distinct ways to load data into a table.
INSERT INTO Table (field1, field2) VALUES ('string1','string2')And
INSERT INTO...
2013-02-28
3,348 reads
Multiple instances, single query window
Anyone who has been reading my blog for a while should realize that several divisions in my company have been...
2013-02-18
1,006 reads
Duplicate rows in a table
I recently got the following email:
“I just keyed in two rows into a table with all identical column values. How...
2013-02-11 (first published: 2013-02-04)
3,244 reads
Something to watch out for when using sp_rename on Stored Procedures, Functions and Views
For those who don’t know, the stored procedure sp_rename allows you to change the name of a user-created object. Basically...
2013-02-11
2,333 reads
EXECUTE, not required, but advisable.
The other day one of the developers I work with gave me a script similar to this:
BEGIN TRAN
sp_rename 'tablename.columnname', 'newcolumnname'
COMMITHe...
2013-02-06
759 reads
Small changes, big effects
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,246 reads
My view isn’t reflecting changes I’ve made to the underlying tables.
Problem: You’ve added columns to the base table of one of your views, but the view isn’t reflecting the change.
Over...
2013-01-29 (first published: 2013-01-21)
3,834 reads
Model database
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
926 reads
IsMSShipped
I just wanted to do a brief highlight of a handy little object property. For those of you who aren’t...
2013-01-23
1,436 reads
Blogs
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Using ChatGPT for Writing
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Forums
MSSQL Service Broker DSQL operation on another database causing Broker failure
I have established a Service Broker configuration based on Eitan Blumin's excellent example. Advanced...
Validating Password Expiration
Comments posted to this topic are about the item Validating Password Expiration
Extracting multiple fields from one column
Hello, I have a situation. I am trying to show each distinct...
Ask SSC