SQL_Surfer (10/8/2015)

---

I have two tables. Table A has 2162 rows and table B has 101 rows. There isn't any join keys that I can join on these two tables. But...

You can do a brute force dictionary query against the sys.sql_logins table.

http://www.sqlservercentral.com/Forums/FindPost1623412.aspx

When I say ad-hoc queries, I'm referring to scenarios where users are typing SQL into a query tool ad-hoc, or perhaps where an application has a search feature with an...

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.