GilaMonster (11/26/2008)

---

That's not a decrease. 1.3e+010 is scientific...

Let's see how it goes with MIN 5000 and MAX 17000

Initially it got even more frequent (with just MIN set). Then I decreased the MAX and it hasn't happened since...

Thanks Gail

I think Total Working Sets dropped when it happened (_Total and sqlservr)

it was 7000000+, and now 1.3e+010 (sql: 1.2818e+010)

peaks were 2.2102e+010 and 2.0922e+010 respectively

I'll keep an eye on it...

I remember reading someone writing something (PASS-related) about next version of SQL may entertain the idea of

FOREACH

Maybe that will replace the sp_MSForEachXX functions

I almost want to bet Microsoft SQL...

I think it's similar in 2005 and 2008

In SSMS

Database -> Storage -> Full Text Catalogs -> right-click on the catalog -> Catalog size (also shows you # of rows)

For example,...

I know there are articles on execute SP on SQL startup, haven't seen shutdown

You could add a script/file to run in Group Policy, then maybe call SQLCMD?

Start > run >...

demtri2002 (11/25/2008)

---

Hi all,

I have setup a Full backup (subplan1) in Maintenance Plan, it works ok. I want to setup a diff backup (subplan2). There is a problem that I selected...

or use SQLCMD with the -E flag?

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

sqlcmd

[{ { -U login_id [ -P password ] } | –E trusted connection }]

[ -z new password ] [ -Z new password...

I recommend SQL Compare from Red Gate too

but there are some free good ones as well

http://www.xsqlsoftware.com/Product/Sql_Schema_Compare.aspx

What is included? The free lite edition of the xSQL Bundle includes the complete suite...

Once you get a correct rows dataset, it's easy to PIVOT into what you want (columns)

RowsBeforeQualify is only meaningful if you also consider the id (which puts the dataset in...

How would you want the outputs?

so for 3-row sets, do you want all sets shown together (like my final SELECT)

or SELECT * FROM Set1, SELECT * FROM Set2, etc.... (like...

I login as myself (Run As, windows authentication), and I can change SQL jobs owned by others (even sysadmins/sa)

I don't fully understand

MS has a sp_help_revlogin (google it) to help you generate login scripts (along with SIDs and passwords)

If you're moving within the same domain, SQL Server knows to...

Just keep in mind 2005 cannot open 2008 files

so VS2005 cannot open VS2008 project/solutions (VS2008 CAN open VS2005, and upgrade them)

so keep your 2005 and 2008 projects separate if you...

It's only a matter of time before disk spaces run out, and then tape

2 ways

1. Increase storage space (buy bigger disk, tape)

2. Decrease storage used (compress, shorter data retention,...