Thank you for your response. I'm...

How about this approach:

1. create a second file group for the database, call it *Idx_group*

2. create one file there Idx_file, the file is sitting on a dedicated SAN *Index_SAN*

3. all...

Jeffrey Williams-493691 (2/16/2010)

---

Really bad idea to schedule a shrink of the databases every night. Why do this, just so the database can grow the...

Thank to All for your prompt answers!, they helped. I identified a couple of daily jobs that

1) shrink all databases

2) do daily backup for all databases.

the jobs are owned by...

this task is tough and has to involve regular expression techniques. Please visit

http://regexadvice.com/forums/

and ask the qustion ther . Don't forget to include the real examples og the...

are you guys just warming up for the Q-A sessions or something? Not sure what you mean exactly. One thing for certain is that your Monday started well.

MrBaseball34 (12/8/2008)

---

I need to select the top record from a query and store two values from it into variables.

something like this:

DECLARE @MRN1 int

DECLARE @DrID int

SET @DrID,...

Seth,

thanks a lot for the info and the time you spent. I'll try what you siggested.

Sergei Z

another technique would be to use a Table-Valued function to pass MultiValue param's values to a store procedure. That is widely used in SSRS reports.

something like

...

many people say that O'REilly books are the best, and I tend to agree sometimes; thisis one of their latest ones on SQL:

Learning SQL on SQL Server 2005

By Sikha...

i can recommend these books:

Beginning Transact-SQL with SQL Server 2000 and 2005

byPaul TurleyandDan Wood

Wrox Press 2006 (594 pages)

ISBN:076457955X

Robert Vieira

Beginning SQL Server™ 2005 Programming

Copyright © 2006

if your target table realy has > 65M recs, then *LIKE* part [BOLDED] in your query

WHERE (PA.change_date >= @Activity_Start_Date AND PA.change_date < @Activity_End_Date AND PA.change_desc LIKE...

this Jeff Moden's function for calculating work days should help:

http://www.sqlservercentral.com/articles/Advanced+Querying/calculatingworkdays/1660/

Ryan,

your guess was correct. Thank you for quick answer. I'm not even going to pretend it was a mental block for me ;=) simply did not think about double quotes...

try and see how the above regex works in this online tester:

http://regexlib.com/RETester.aspx

it will not do replace, just will show u matches and groups