Viewing 15 posts - 1,816 through 1,830 (of 6,035 total)
Assuming each query has the same parameters and the data was static between executions, I would expect the number of page reads and the execution plan to be the same....
January 18, 2017 at 7:11 am
Hi Ben,
Using the following Google search expression, I was able to find the diagram you're looking for or at least something similar. It looks like there may be several...
January 17, 2017 at 3:47 pm
January 17, 2017 at 12:37 pm
OK, I now see this was entered under 'Articles Requested'. I thought it was a general question. Offhand, I don't know of any limitations that TDE would place on other...
January 17, 2017 at 8:53 am
Generally speaking, there is no good reason to repeatedly shrink a database on a schedule. What this does is reduce the physical size of the data file on disk. The...
January 17, 2017 at 8:17 am
I am currently working on design phase of an integration of a new CRM system...
January 17, 2017 at 7:59 am
In the case of a distributed database environment, like retail point of sale, I'd use a composite key like StoreID + TransactionID before I would resort to using GUIDs. So...
January 17, 2017 at 7:48 am
This is an old thread, but
1. So the files do not become further corrupt, make a backup copy of the .mdf data and .ldf log files. This files should...
January 17, 2017 at 7:38 am
I'm not seeing a link the original article, so I'm not sure about the question. However, regarding the question of using TDE with database Stretching, I don't see why it...
January 17, 2017 at 7:14 am
The following website has a collection of 3,000+ visual studio themes for download, which also can be imported into SSMS. You can even create new themes here as well.
January 16, 2017 at 11:08 am
Unless my off-hours learning and hobby programming turns into a full fledged side business, I don't plan plan to ever spend $,$$$ for a personal on-premises (ie: setup in my...
January 16, 2017 at 10:56 am
January 16, 2017 at 9:10 am
SQL suffers from the same predicament as HTML and JavaScript; it's an accessible high-level language that's widely used by a lot of people, but only a few people actually know...
January 16, 2017 at 8:34 am
Yes, the service account used for the honeypot server should be local no admin minimal priv, the mssql account left open to the public should itself be nothing more than...
January 14, 2017 at 8:18 am
I'm no expert on tempdb, but I have a couple of thoughts, like what's your initial size and auto-growth setting on tempdb?
You can use the following query against...
January 13, 2017 at 1:44 pm
Viewing 15 posts - 1,816 through 1,830 (of 6,035 total)