EdVassie (10/8/2015)

---

I think IoT will lead to a significant change in Computer Misuse legislation all round the world. In order to counter the viruses that will go round infecting...

terry999 (10/9/2015)

---

Thank you v.much Eric

That is a good idea, it is simple to understand. I went for the permissions in the end.

All new data is protected. I can still...

null

It seems to me that 6 GB is very low end for a database server today. I've got more memory than that on my laptop. Even 12 GB is low...

For an OLTP database (medium size tables, single inserts, many users, mostly small repetitive queries), you want re-usable query plans as much as possible.

However, in a data warehouse (very...

Markus (10/8/2015)

---

If you are THAT green look into the 5 day SQL Server DBA class from a Microsoft certified training facility. On youtube there are some good step by...

The SQL query is executed server side, so it will run approximately the same, regardless of where it originates (SSMS, SSRS, stored procedure).

Adding columns to a table requires an exclusive table level lock, so it may be in a blocked state.

Also, if the columns have a default value, then it's an...

Here is me getting assigned tasks:

Take a look at the email I just forwarded.

Figure out what's going on.

Fix it.

Let me know as soon as it's done.

Run this to get a breakdown of how much memory is allocated to each memory cache,. The page buffer cache is CACHESTORE_OBJCP and query plan cache is CACHESTORE_SQLCP.

Select [type],SUM([single_pages_kb]) As...

I only use triggers as a last resort, and this isn't one of them. One technique you can use is to add a column containing a CHECKSUM() of whatever columns...

Soundex has been around since 1918 and it's algorithm for letter substitution is documented here:

https://en.wikipedia.org/wiki/Soundex

Perhaps you can use REPLACE() function to massage the keywords before you do SOUNDEX() comparison.

SOUNDEX(replace('Kolton','K','C')) =...

All the folks committed to psychiatric hospitals during past decades, because they were convinced their TV and refrigerator were spying on them, we can let them all out now.

They're no...

Hey Kim, when you get it all working and identify...

Personally, I'd rather not deal with 100 separate SSIS packages, even if they are auto generated by BIML. If you can leverage BIML or .NET to programmatically modify the DataFlow...