Hi,

dropping objects or deleting rows will not reclaim occupied space unless you explicitly run commands to reclaim space.

when your file group is full and no more able to allocate additional...

Hi,

http://www.sqlskills.com

Hi,

You can make use of SSRS to develop custom reports.

Hi,

go through below url, might help you to configure SSRS timeout settings.

http://technet.microsoft.com/en-us/library/ms157273.aspx

Hi,

if you are analyzing IO sub system latency then go through below blog post.

http://www.sqlskills.com/blogs/paul/how-to-examine-io-subsystem-latencies-from-within-sql-server

Hi,

i too go for export table option rather than backup/restore just for few tables.

SAN storage administration i love to explore in addition to DBA activity.

Hi,

Yes you can upgrade from Windows server 2003 SP2 to Windows Server 2008 R2 Standard/Enterrpise 64 bit provided your existing 2003 server is 65 bit as upgrades from...

Hi,

basically you do not need to create database name and structure before restoring it.

if your backup files are pointing to different disks then you need to point them to right...

Hi,

seems to me somewhere your recovery model changes to simple thus breaking log chain, investigate if there any bulk operations changing recovery model.

Hi,

In short, yes you can restore database to new server and login which restores the database will become owner of that database.

hope this helps..

Hi,

If you want to learn and practice,

I have listed few good free resource which provides you video tutorials, hey are very detailed and professional.

click here[/url] for more details.

what output do you expect from above table

hi,

is this what you wanted..

SELECT t1.Busname ,t1.BusType , MIN(StartDateKey) StartDateKey , Case when t1.EndDatekey is null then null else t2.EndDatekey end EndDatekey

From @temp t1

Left JOIN( SELECT Busname,BusType ,...

hi,

refer this link.

http://www.sqlservercentral.com/Forums/Topic1108211-391-1.aspx