antonio.collins (1/6/2008)

---

how can this:

select * from monitor_hosts where @myList like ('%,'+cast(hostid as varchar(8)+'%')

be faster than this:

select * from monitor_hosts where hostid in (select val from dbo.fListToValues(@myList))

the first statement will always...

If you're using the function as a table, you can simply join to it. We do it all over the place.

Unfortunately, table valued functions don't have statistics, so if the...

The link to the ZiffDavis IT myths doesn't seem to be working.

I agree with Jeff here. Naming tables after the database they're contained in is not going to be helpful. Also, I wouldn't recommend using the module in the names. I'd...

Inside the SQL Server 2005 folder is a folder called Configuration Tools. Inside there is a tool called SQL Server Configuration Manager. Open that up. In there on the left...

Is "E" a drive or a share name?

It has to be permission issue from the service account that SQL Server runs under. Not the 'sa' login, but the login...

So far we only three or four schema per database. We manage our security through a role in the database. The roles get access to stored procedures. The stored procedures...

BOHICA

:w00t:

To my knowledge, not using this quick way of scripting. If you do an actual export to file you get the option of having a single file or seperate files...

I'm not sure what you mean. We're not talking about tables, but about stored procedures. If you have a data type of int in the stored procedure, the character length...

This isn't documented, but does what you want:

exec sp_procedure_params_rowset 'procname'

The -1 returned by the view is the designed method. The procedure, in my mind, is worse. It shows a length...

Personally, I use autogrow. But, I recognize that it is a crutch. I spend a lot of time & effort in setting up monitoring so that I know how much...

SELECT * FROM INFORMATION_SCHEMA.PARAMETERS

WHERE SPECIFIC_NAME = 'myproc'

That'll get you exactly what you want

I agree, if you have no information on anticipated load, etc., about 25% of the initial data size would be a prudent number.

However, I'd make sure I had a more...

Just remember that short-hand notation like BTW, OTOH, IIRC, are for very informal communication. You can use them on line, but you wouldn't want them in formal documentation, requests for...