SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s...
2012-07-11
1,280 reads
SQL RNNR
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say...
2012-07-11
12 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2012-07-02 (first published: 2012-06-25)
4,488 reads
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
14 reads
Database In Recovery
What do we do?
Have you ever run into a database that is in the “In Recovery” state?
If that has happened,...
2012-06-04
1,271 reads
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
7 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that...
2012-05-18
869 reads
SQLSat 142 – Waltham
Wow – have I ever been dark and silent this past couple of months. Nothing like the present to reverse that trend. I do have a good excuse for...
2012-05-18
8 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log...
2012-04-02
857 reads
Move the T-log file of the Mirror Database
On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored. Then a hiccup comes along –...
2012-04-02
8 reads
Blogs
From SQL Saturday to Day of Data
By ReviewMyDB
A behind-the-scenes look at Day of Data Jacksonville 2026, the transition from SQL Saturday,...
PostgreSQL 18 Finally Makes BUFFERS the Default. Here Is Why That Matters
You run EXPLAIN ANALYZE on a slow query, stare at the plan, and something...
A New Word: La Guadière
By Steve Jones
la guadière – n. a glint of goodness you notice in something that you...
Forums
non ascii columns in a utf-8 .txt file
hi, we couldnt get our upstream data source developers to supply what is sometimes...
PolyBase Trace Flags
Are there any good articles on all the trace flags that are enabled on...
The Data Model Matters
Comments posted to this topic are about the item The Data Model Matters
Question of the Day
Running SQLCMD I
I run the SQLCMD utility as follows:
lcmd -S localhost -EI then type this (the 1> is the prompt):
1> select @@version goIf I hit enter, what happens? See possible answers