paraphernalia

Jack Corbett (3/5/2010)

---

As far as the test, I think I could have passed it without any studying and if you have experience with the enterprise level of the version you...

Grant Fritchey (3/5/2010)

---

I don't know who this top-level Grant guy you're talking about is.

I recently interviewed at a company where it was made pretty clear, just how little I know....

Lynn Pettis (3/5/2010)

---

Then I should definitely take the certification.. 🙂 I am no Gail or Grant. 🙂 They even have Black belts and the only belt I have is the...

you're welcome.

Jack Corbett (3/5/2010)

---

For those not on Twitter, I passed the 70-432 Implementing and Maintaining SQL Server 2008 exam yesterday. Easier than I thought it would be. If...

You're welcome

What you describe is similar to what would happen if the public role had been locked down.

Here is an article that discusses security and locking down sql server.

http://duartes.org/gustavo/articles/Lock-Down-SQL-Server-2005.aspx

Some resources:

http://support.microsoft.com/kb/225545

It seems that the application and database are competing for resources - memory being a good contender.

What are your memory settings for sql server?

Also, I would tune your sql queries...

Has anybody locked down the public role?

Henrico Bekker (3/4/2010)

---

Personally, I want to say yes, but it depends on where you want to go with SQL development, maybe into BI? then, YES.

Also depends on the needs of...

This will eliminate the "NOT IN"

with apples as (Select [name] from tablename where fruit = 'Apple')

Select distinct t.Name

From TableName T

Left Outer Join apples a

On t.name = a.name

Where a.name is null

I can tell you that a bare minimum ability to understand at a basic level is necessary. Being able to look at .Net code and understand what it is...

It depends on whether you need to or not.

Will it be beneficial - sure.

You can apply what you learn in .Net to CLR procedures and to SSIS packages. Both...