first, a reminder: ALWAYS STORE DATES AS DATES.

from your sample data, it looks like you are storing as varchars, and converting varchars to dates and then dates to varchars introduces...

the answer is no, then.

speeding up of the queries will require indexing changes /additions based on the common WHERE statements being used;

partitioning for performance, like Gail mentioned, is WAY on...

azadrazvis (12/10/2013)

---

Hi

I am trying to create logins for multiple windows users to login in to sql server 2012 but after creation of login and database user...

this is the query i use for defining object ownership:

;with objects_cte as

(

select

o.name,

...

you could add a serverwide DDL trigger that watches for drop database, and issue a rollback command.

that would not prevent a sysadmin from disabling said trigger, nor from restore the...

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...