showing us the actual query would help, and whether the query is performed in a procedure or ad hoc;

the actual execution plas, posted as .sqlplan, would let us identify the...

Cpt_Picard (12/9/2013)

---

I've set up a new SSRS 2012 instance pointing to the local Database Engine and got an error I'm having trouble resolving. I have not changed the RSreportserver.config file...

alan.hollis 1097 (12/4/2013)

---

We're having a slow query problem with SQL server.

We have some software which is using a virtual host name of the SQL Server Listener in the query and...

hornak.john (12/8/2013)

---

I've tried everyone and no one.

There is no security on the file side of the linked server so I don't know how to set up the security on the...

based on the name, [BO_Custom.dbo.Property_Coordinators_Summary] appears to be a view, which probably is a GROUP BY on the Property_Coorindators anyway.

you know your data much better than we do, especially...

I've always moved CREATE statements to a single file, and INSERT statements are not insert statements at all, but actually files exported via BCP;

then i write the appropriate BCP/BULK INSERT...

in both SQL and SQLite, a view is a saved select statement.

it's pretty much just CREATE VIEW VIEWNAME AS SELECT.....

where are you having trouble? do you want to materialize the...

one of the things that is going to make this slow is the linked server;

the execution plan will end up copying the entire table over to tempdb, and THEN...

you can and will find that login and logout events could be missing, due to connection pooling.

this stackoverflow post explains it, with the linky to the microsoft article as well:

http://stackoverflow.com/questions/279401/sql-connection-pooling-and-audit-login-logout

http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

your...

DBANoobie (12/6/2013)

---

Hello all-

I was recommended to this site for all the wealth of knowledge and I was hoping ya'll could assist me with this. I am new to the DBA...

does the startup account of SQL server have...

This way be an object name, and optionally parameters after object name

exec @sqlStr

THIS way, you can execute a string command: note the parenthesis!

exec(@sqlStr )

As I understand it, there will be no significant impact at all;

if you look at the execution plan, all objects are extracted out to their four part naming convention anyway;

I...

On The server NJACCOUNTING01, look at the indexes on the table marlin_test.dbo.apdoc

an index like this would greatly help the query, i believe:

CREATE INDEX IX_apdoc ON dbo.apdoc(Crtd_DateTime,DocType,VendId) INCLUDE (user1,vendid)

see what indexes...

Tina there's quite a few things i'd do differently as far as the naming of tables and columns; Tables don't need tbl_ in front of the name, and the PK...