hetkeval2005 (5/26/2009)

---

As par adv and disadv, you are right to go with windows authentication, but for cost and time wise, i think it is good to go with SQL Authenticatin...

If all of your application end users are within the company and on the active directory, it is much better to go with windows authentication. Don't fight it..... ...

You'll have to update the post with more information about the tables we are selecting from. You've given only a small amount of information about the 'Problem' table. ...

Lynn Pettis (4/11/2008)

---

As the question specificaly mentioned SQL Server 2005, you could queue up a COPY_ONLY backup to start when the scheduled backup finished. This copy_only backup would not...

zzx375 (5/19/2009)

---

And I read the question from the perspective of the value of the information found in the view.

sys.system_sql_modules always returns 1 for uses_ansi_nulls and uses_quoted_identifier. All by itself,...

Select count(date_logged) as M_Count, datename(month,date_logged) as M_Month

FROM incident

WHERE

date_logged > '20090101' AND date_logged < dateadd(mm, +2, '20090101')

group by datename(month,date_logged)

just add the select for your "type" and you are good to...

Use this and then create a cross tab report in ssrs's reporting wizard:

Select count(*), Month(date_logged)

FROM table1

WHERE

Month(date_logged) between Month(dateadd(mm, 0, @AktuelleDatum)) and Month(dateadd(mm, -2, @AktuelleDatum))

and year(date_logged) between year(dateadd(mm, 0, @AktuelleDatum))...

It's the Peter Principle. Everyone talks about it but hardly anyone follows it. Management assumes that excellence at a technical role whether it be DBA, welder, programmer, etc...

Here's a free tool:

http://www.mssqltips.com/tip.asp?tip=1083">

http://www.mssqltips.com/tip.asp?tip=1083

Please give us some sample data so we can better help you:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Subtle difference in 'freeing up space' vs shrinking...nice question:

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

Truncation does not reduce the size of a physical log file. Reducing the physical size of a log file requires shrinking the...

So what happens after you connect to a database? Are you talking about the "server type" drop down in the 'connect to server' dialog?

Part of finding a good recruiter is one who is committed to the business. One that is successful, has lots of experience, and enjoys the work. So I...

from BOL "Create Database":

Here comes a curveball. Instead of focusing on the best way to find and screen DBA talent, spend that time looking for an excellent technical recruiter. Hiring talent...