Remember that ultimately your boss is writing your reviews and any future references you might need. If your boss is not supportive when you do what you were hired for,...

I've always been in small shops in more of a Hybrid role where I do DBA and SQL developer tasks, and to be honest have been more of a SQL...

I have to agree with all 3 of Grant's suggestions. I would add a 4th, get with your manager and clarify why you were hired in the first place...

jvisagl (2/29/2008)

---

Thanks for your response.

1)Yes

2)BID

3)Yes

I figure out how to do it. I used the wizard and this save a copy. But now I am trying to understand how this works....

Glad we could be of help. The datareader should be faster when only accessing data and should be less resource intensive.

Autoclose is designed so SQL Server will return resources to the system and the default is off. It should never be on for any application used on a daily...

I'm not sure what you mean by "assign a string to a column name". Do you mean you want to dynamically select the columns based on a parameter? ...

Even for an expected 50-100 records cursors are very inefficient when compared to set-based code. It is not just long-running queries that need to be fixed it is also...

As I was typing that post I thought, can you disable DDL triggers? If not would the DDL trigger catch a disable trigger statement? Unfortunately there is always...

I generally have not had to worry about people modifying columns because I never, grant direct modify permissions to a table, I actually rarely grant select on tables. Everything...

It's not that you are bothering me, but you need to use the resources you have and BOL is a good resource. That should be the 1st place you...

Ever heard of Books on Line. You look there for sp_add_jobstep and it gives you all the parameters that go with and their usage.

The parameter is @step_id and you...

I would actually run the CheckPoint command and let SQL Server take care of itself. I posted this on your other post about the tempdb problem.

Running DBCC...

From BOL:

CHECKSUM satisfies the properties of a hash function: CHECKSUM applied over any two lists of expressions returns the same value if the corresponding elements of the two lists have...

Check out BOL for Dynamic Management Views. There is one called sys.dm_exec_connections that has user connections. There are many others that may have information you want as well.