like SQLSACT said, you need something in place already to get "by hour" counts.

for example, this query gets the # of rows in each table. if you saved the results...

late response, but here's my advice: switch to using the 2012 SSMS immediately.

the differences are minor, but they are there, and there's no valid reason to be afraid of the...

Like Perry, I'm not sure where the question is, but i'll throw out a...

my first guess is that you ar emissing a GO statement;

you've got the CREATE / ALTER, and then a call of the same proc on the last line...so it calls...

raysteve43 (11/18/2013)

---

I am trying to upgrade to SQL 2012 from SQL 2005. I have a job that deletes expired records from a single table one a month....

answering my own question:

found a post that referenced "linked server" along with the error;

it pointed out that toggling this option on the linked server from true to false resolved the...

assuming you would join Source_X_Entity to the other two tables ,

i would think that if you create a non clustered index on Entity(NaturalKey), or maybe a non cluster on(Entity(EntityID)...

but a logon trigger would not tell what or when a database was accessed; it only fires at login, and...

yeah that's one of the problems with a linked server; data gets copied over to tempdb, and then joined to your data locally, so you could see a million+ row...

ahperez (11/18/2013)

---

Well, since this is a third-party app this might not be a practical option. Auto update stats is a database level command, impacting the whole db. Below is the...

temp_int_field DOES NOT EXIST in #sub_table, it's a column in #temp.

because you are not aliasing your columns, it isn't obvious that that is the issue at first glance.

--this works, becuase...

George i have the Redgate SQL Search plugin added, and it searches meta data only: object names from sys.objects, and definition text from sql_modules.

Sean Lange And I have a couple...

winston, i think one of the built in extended events session templates, along with where you would add a filter on database Id, is probably what i'd look at first.

In...

i think there is a built in function for that, [&UserID], right?

Getting Windows USERID in SSRS report

dba schema, or was that a misspelled dbo?

here's my code modified to use your table...if you spelled your tables and columns right, i think this will work as advertised, assuming...