Sql Server & SSRS Tips

Read article from their http://download.microsoft.com/download/C/C/A/CCA2C3E3-D441-4161-AE5F-94F0A5D70ED4/SQL%20Server%202008%20R2%20Spatial%20Data%20Whitepaper.DOCx "Only for reading purpose" Delivering Location Intelligence with Spatial Data White Paper Published: August 2007 Summary: The growing ability of businesses and consumers to quickly absorb large volumes of data, together with the increased availability of digital maps and spatially-enabled applications has created an unprecedented opportunity to incorporate geographic factors into decision making processes and analysis. The new spatial support in Microsoft SQL Server™ 2008 R2 can help you to make better decisions through visual analysis of location data that can be stored and manipulated in a SQL Server database... Contents Introduction ...................................................................................................................... 1 Comprehensive Spatial Support ........................

Read this article by this link "http://www.petri.co.il/create-backup-job-in-sql-server.htm" First you start by opening a query window in SSMS and connect to the server you want to backup.  It’s worth noting that it doesn’t matter which database you’re connect to, but I typically do it from master just to be consistent. The basic backup syntax that you need to type is here: BACKUP DATABASE databaseName TO DISK = 'file location' OK, let me explain a couple of these items. BACKUP Database – T-SQL command for what you want to do, which in this case is backing up a database. databaseName – this is the name of the database you want to backup. To disk = 'file location' – Backups are written to files.  This is the full path to the file.  Typically, a full backup such as this one will have the extension of .bak, but that’s just what everyone does.  It can have any extension you like or no extension at all if you like. Now let’s see a real example with all o...

If you have many rows in details of SSRS reports and in preview mode your one or more line moves to nect page but you want to keep them together. so first select all rows and set "keep together" to true from properties and also set keep together property from advanced (a small triangle at the groups). If the records are still move to next page then right click on report background and click on reports properties and increase the height of report a little bit. your problem will be solved

When an empty page is coming at the end of SSRS report , then check the width of report in its properties and increase its width....

SQL Server backup media A database may be backed up to disk or to tape. The examples in this article assume a disk backup directly into a disk file (as opposed to a disk backup device). Any database can be backed up to a random disk file at any time. The file may either be initialized (using WITH INIT) or appended with the new backup. Types of backups in SQL Server SQL Server provides several different kinds of backups including Complete , Differential , Transaction Log , and File(s) and Filegroup(s) backup. A combination of these backups may be used to formulate a robust disaster recovery strategy. The following paragraphs explain each SQL Server backup type Complete database backup A complete database backup creates a stand-alone image of the entire database. A complete database backup is self-dependent and may be restored to either the same or a new database on the same or a different server. This provides plenty of flexibility at the time when this backup has to be ...

Full Backup: A complete backup of everything you want to backup.                       A full backup contains all the data in a specific database or set of filegroups or files, and also                               enough log to allow for recovering that data. Benefits:     Restoration is fast, since you only need one set of backup data. Drawbacks: The backing up process is slow.                     High storage requirements. Differential Backup: The backup software looks at which files have changed since you last did a full backup. Then creates copies of all the files that are different from the ones in the full backup. If you do a differential backup more than once, it will copy all the files, or parts of fi...