Server-Side Trace Pack
Loads temporary stored procs that assist in running and monitoring server-side tracing.
2012-03-12 (first published: 2012-02-21)
1,067 reads
Production Support
RE: Remove alpha characters
Jonathan, I agree about using 'STUFF' - in fact, when I went back to my code to copy it into my message, I realized that I had used 'STUFF', rather than concatenatation, but re-wrote it to confirm my original claim.
2003-12-08
1 reads
RE: Store Key - Storing Misc Data
By the way, just looked at the thread you posted and I feel that there should NOT be two lookup tables in that situation; statuses of court cases are the same logical types of entity, are they not? "OPEN PENDING TRIAL", "CLOSED CONVICTED", etc (assuming these are actual possible statuses), could all go into a […]
2003-12-05
RE: SELECT FROM a WHERE {end bit of field} not in B..?
Maybe something like: select * from Table2 where substring(email, charindex('@', email) + 1, len(email)) not in (select domain from Table1) Assuming of course that email is not null and will always contain a valid email address. Cheers, mia Life moves pretty fast. If you don't stop and look around once in a while, you could […]
2003-11-27
1 reads
RE: Transaction Log Backup
quote: After every full backup I automatically run these 2 commands to reclaim the space the TLog has allocated: backup log DBName with truncate_only DBCC SHRINKDATABASE (N'DBNAME', 0,TRUNCATEONLY Have you ever tried a test restore? If you truncate the log without backing it up (as with your statement), you have broken the chain of tran […]
2003-11-26
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers