If you've got deadlines, and slowly growing nested views, then this links is for you and your boss:

http://usingimho.wordpress.com/2012/02/27/on-technical-debt-now-with-chickens/%5B/url%5D

Adding another view on top of views is selling a chicken.

To sum up:

Your resume...

krowley (9/10/2013)

---

I still don't see a lot of good answers to the basic question. If I wanted to apply for a job as a DBA (mid level or higher) and...

Stephanie J Brown (9/10/2013)

---

Certifications present a certain set of information. As I see it, the two main problems are:

...

2. Hiring managers assuming the certificate guarantees things which it...

First idea: Educate your boss quickly.

Second idea: Ask your boss to name the views based on when they'll no longer be needed, so you can see what to clean up.

Third...

I agree completely that testing task knowledge is superior to testing syntax, and I'd suggest that testing syntax is more tightly tied to selling "stuff" than testing task knowledge. ...

As stated in my post, no, my dm_exec_connections query only shows the ports and local IP addresses that have currently open connections at the time the query is run, and...

SQLSteve (8/16/2013)

---

Or you could run ---

DECLARE @portNumber NVARCHAR(10)

EXEC xp_instance_regread

@rootkey = 'HKEY_LOCAL_MACHINE',

@key ...

Check what the user is actually calling "slow", and how often it's "slow".

Then check what the user considers "normal" for this process, and how often it's "normal".

Then start investigating, probably...

Without the actual table schema and naming rules/business logic, and any other tables that might help, the only accurate solutions all involve redesigning your schema so banks and foundations are...

I...

Yes.

SQL Server Configuration manager, SQL Server Network Configuration, Protocols for <instance>, TCP/IP, Properties, at the bottom is IPAll - remove the TCP Dynamic Ports string and put 1433 in TCP...

Alternately:

EXEC sp_configure 'show advanced options',1;

RECONFIGURE;

EXEC sp_configure 'min server memory (MB)',8192;

EXEC sp_configure 'max server memory...

We also share responsibility:

DBA's handle Database<->Disk and disk retention/aging, automated and ad-hoc and PITR.

Backup team handle Disk<->Backup software (disk and tape), automated and ad-hoc, and tape retention/aging.

DBA's get requests, and...

There's also the code way of handling this:

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'LinkedServerName', @locallogin = N'MySQLLogin', @useself = N'False', @rmtuser = N'RemoteServerUserName', @rmtpassword = N'RemoteServerPassword'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'LinkedServerName',@useself=N'True',@locallogin=N'MyADLogin',@rmtuser=NULL,@rmtpassword=NULL

-- remove the default login...