There has been more than one occasion in the past where I would hire on full-time at a company and then conclude within the first 90 days that the job...

thebrewersinaz (10/9/2015)

---

Hi our group is debating whether we should use views or data marts. WE have some huge queries that can have many joins up to 20 in some cases....

Kristen-173977 (10/9/2015)

---

...

The actual code to do the CSV part was trivial, but we did need to take care of properly quoting columns that had embedded commas, and then double-quoting any...

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')) =...