Sean Lange (10/30/2015)

---

Michael L John (10/30/2015)

---

Brandie Tarvin (10/30/2015)

---

Anyone here with mad C# skills? I need some help with a VS 2012 C# project that I'm updating.

Nevermind. One of our developers...

* How do you structure your reporting services projects? eg, do you create a new project for each... "group" of reports? If so, how do you group reports?

Multiple projects, usually...

sgmunson (9/24/2015)

---

Still looking for guidance, if anyone has any, with regard to exactly how to go about determining what pages belong to a specific table, and then being able to...

Just add WHERE BD.OD_RIT <> BD.D_RID then. Surely you could have worked that out? 🙂

I'd probably be using something like the code in your first post, with PIVOT or the cross-tab method.

Jeff has a couple of articles on it here: http://www.sqlservercentral.com/articles/T-SQL/63681/

With that many decline...

Increase your timeout? It's a property of the connection so it needs to be done in C#.

Although I can't see why that code should take > 30 seconds to run.

Perry Whittle (9/18/2015)

---

when you shrink you'll likely undo all the rebuild or reorg work anyway as pages may get moved during the shrink operation, so your efforts in the first...

erichansen1836 (9/17/2015)

---

So now we're saying 32 bit processors can't seek past 4 gigs? Tell me more!

edit: Seriously, I don't write big files, so I haven't had to deal with this,...

Don't envy you this task, sounds like changing a database collation but less fun!

I'd be fighting hard to change columns to built in datatypes rather than new/modified user defined types.

For...

Lynn Pettis (9/15/2015)

---

vedau (9/15/2015)

---

I had done something similar but to validate the backups. Here are the steps that I used.

1. Share PROD backup folder so that you can access it...

You can, but I doubt it'd be worth it. Just place it as you would a normal user db, with data & log files on different drives.

It's not used nearly...

GilaMonster (9/15/2015)

---

Gazareth (9/14/2015)

---

To avoid downtime, it could be possible to add a new logfile on F to each DB , then issue a shrinkfile with emptyfile on the old one;...

SSIS, SSRS, maybe Powershell?

You can use the Export wizard to create an SSIS package, you'd need to modify the package to add the email & scheduling afterwards.

SSRS can generate the...

In SSMS:

ALTER DATABASE [dbname] MODIFY FILE (Name = Logfilename, FILENAME = N'F:\....\')

GO

ALTER DATABASE [dbname] SET OFFLINE

GO

*Outside SSMS* Move/copy files to new location on F:

*In SSMS, after copy's complete* ALTER DATABASE...

Have you looked at the execution plans for both varieties at all?

Wild speculation, but could be that the use of the date index adds key lookups/bitmap probes which might be...