The RDBMS is Often the Right Tool
Today Steve gives reasons why he thinks the RDBMS is often better than a NoSQL database of any sort.
2019-02-27
73 reads
RDBMS
2020-01-28 (first published: 2018-12-06)
570 reads
2018-09-13
134 reads
The Age of Multiple Databases
There are lots of databases to choose from. Steve discusses using more of them in your work.
2018-07-16
93 reads
RE: Cross-server query in a stored procedure
cross-server queries are considered heterogenous queries so you have to set ansi_nulls/warnings "on" with the "GO"s then you have to create the procedure in QA (because you cant put three seperate statements in a "create sp window" in Enterprise Mangler. Once it is created you can alter it in Enterprise Mangler.
2005-05-20
SELECT COUNT(*) or COUNT(1) Performance or Benefits?
What are the advantages of using COUNT(*) -or- COUNT(1) in the following examples:declare @Address1 int select @Address1 = count(1) from dbo.Customers where ID < 0 select @Address1 as Address1countdeclare @Address1 int select @Address1 = count(*) from dbo.Customers where ID < 0 select @Address1 as Address1count
2005-05-10
1,352 reads
RE: Why To Reboot the Server?
I guess your reboot-policy comes from an NT-4 era We only reboot if fixes are planned and installed or if our production-plant has a planned downtime.
2005-04-27
RE: Replication Question
In reply to Scott's question, I will be inserting rows in the same tables as the replicated data, but I would not be updating any rows that were originally replicated. However, he indicates this would be an issue even if just inserting data.I do need clarification on Hilary's reply. She says "by default replication will […]
2005-04-14
RE: Converting DATETIME to NUMERIC
DECLARE @dt DATETIME Set @dt = '1/1/1901 12:01'Select Convert(int,@dt)
2004-06-14
RE: find who accessed
Hi brian if i can ask another question on replication. we have an application in our office MSDE8 as backend and visual foxpro as frontend.now we want to enable replication.i mean users can take our application on their laptop and do some changes to data in offline mode.when they relogin to our main database server […]
2003-12-30
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