Any thoughts/opinions on sp_spaceused?? I often use that ad hoc to get an idea of table size.

Wow! Thank you or the great information everyone! I will read up on the link Jacob Wilkins provided as well.

We created Project B simply to get our feet wet with working with database projects. We are helping another team out with Project A and wanted to familiarize ourselves...

Another option (could possibly be considered a hack) is rather than start the subscription job, instead send a link to the report. I have a job that has several...

Also not a DBA, more masquerading as a DBD. My top three:

select table_name, column_name

from information_schema.columns

where column_name like '%SomeText%'

order by table_name, column_name

exec sp_spaceused 'SomeTable'

exec sp_help 'SomeTable' -- via Alt-F1

I have feedback regarding Ctrl-0 to search for a phrase in an object's script. I have something I've been running to do that as well, but it uses sys.sql_modules...

Am I the only dummy that doesn't look stuff up before answering? I have been going about this all wrong trying to "test" myself! 😀 I assumed...

I have not personally tried this, but I did find this link that may be helpful. Although the example refers to adding the date, perhaps you can get to...

I ran into this once as well. In my case, I was executing msdb.dbo.sp_send_dbmail from one database and was querying a table in another. If this is what...

Hopefully I understood the question correctly. Here is another option. First, here is some sample data:

-- Set up sample tables

if object_id('tempdb..#Table1', 'u') is not null

...

I use this ALL THE TIME. I am on 2008, and I don't have a 2005 machine on which to test this. I'm pasting it as-is with my...

I have had to optimize several poor performing stored procedures and queries at my company and the solution in every case is often different. Here are a few things...

Thank you Sarah for motivating me to get back into the mode of, at the very least, reviewing the current forum topics referenced in the daily email. I used...

I have chuckled about this several times already today! This is great!

As if I don't...

I had assumed responsibility for a process that paid a particular group of our employees outside the standard system (think expenses, as an example). I had to execute stored...