-
It is good if you backed up the LOG file also when we take the full backup of the database. If you are not backed up the .LDF file or LOG then it will become huge and occupy the large number of space, if you need to clean up the transaction log. Follow the following steps and clean your LOG size. 1)...
-
We can backup a SQL Server database to a mapped drive using the following script 1) First it will create Map Drive in Local PC 2) Backup the Database. 3) Delete the Map Drive, so that next time the same script can be used. EXEC master..xp_cmdshell 'net use z: "\\192.168.1.93\share" password...
-
Few days back I was trying to send sql data to my web API using Store-procedure and it was simple and interesting, you can use the same way to call web http post or get both method using such way CREATE function [dbo].[HttpGetMethod] ( @url varchar(8000) ) returns varchar(8000) as BEGIN DECLARE @win...
-
You may know how can we register SQL Server instances with Central Management Servers (CMS) and also how can we perform multi server query will all of instances of registered SQL Server instances. There you can see i have registered one shared SQL Server 2011 instance under CMS and named it Denali. Under...
Posted to
sqlideas
by
Paresh Prajapati
on
12-10-2011
Filed under:
Filed under: sql, sql server 2008, sql server, ms sql, ms sql server, sql server denali, sql server 2011, database, sql server general, enhancements, SQL new features, sql errors, SQL Server Problems
-
Recently I have posted some of the articles and some just learned from the month of October. This article just summarize all the posts which recently published. You can find the links below to go in the details. Blog Posts: Database Backup Compression, Amazing feature for DBA Multi Monitor Support of...
Posted to
sqlideas
by
Paresh Prajapati
on
12-01-2011
Filed under:
Filed under: sql, tsql, sql server, ms sql, ms sql server, t-sql, new features, #SQL Server, #sql, database, sql server general, enhancements, SQL Scripts, SQL new features, JustLearned, query
-
Before Apply Indexes on any Table's Column go through some points 1.) Table Type: If your table is very highly transactional than try to keep less indexes on that table that doesn't mean that don't go for indexing. But for selected columns only because indexes provides fast searching data...
-
Production Database servers may have databases which are heavily in size. For the maintenance of those database backups are very hard and lengthy as the backups of those heavily databases take more tome to execute and very CPU, memory and IO consumptive. And important thing is backups activity should...
Posted to
sqlideas
by
Paresh Prajapati
on
11-30-2011
Filed under:
Filed under: sql server 2008, tsql, sql server, ms sql, ms sql server, t-sql, #SQL Server, #sql, database, enhancements, SQL Scripts, SQL new features, backup, Performance
-
I have drafted all the new features and enhancements introduced by SQL Server denali CTP1 and CTP3 . Multi Monitor Support is the new feature among them. We can do with this feature : 1. Using this feature we can use multi screen of query analyzer or editor. 2. You can monitor separately it and run the...
Posted to
sqlideas
by
Paresh Prajapati
on
11-25-2011
Filed under:
Filed under: sql server, ms sql, ms sql server, sql server denali, #SQL Server, #sql, sql server 2011, database, enhancements, SQL new features, SQL Server Code Named Denali, Denali
-
Getting Started With SQL Azure series: 1. What is SQL Azure? 2. Creating First SQL Azure Database 3. Provisioning and Billing Model 4. SQL Azure Architecture 5. SQL Azure's security model 6. Migrating Databases to SQL Azure 7. Administration Tasks - I 8. Administration Tasks - II 9. Developing SQL...
Posted to
Paras Doshi
by
Paras Doshi
on
11-21-2011
Filed under:
Filed under: Azure, #SQLServer, SQL Server, SQL Azure, sql, #SQL Server, #sql, SQL Scripts, database, ms sql, ms sql server, Windows Azure, SQL-Azure, SQLAzure, Database Migration
-
Recently while working with SQL CLR functionality and created DLL for the SQL CLR. But while registering this DLL in the database i got one surprised error. Lt's show you the script so you have more idea. We have a script to register DLL as following, SP_CONFIGURE 'clr enabled',1 GO RECONFIGURE...
Posted to
sqlideas
by
Paresh Prajapati
on
11-19-2011
Filed under:
Filed under: sql, sql server 2008, sql server 2005, tsql, sql server, ms sql, ms sql server, t-sql, sql server 2011, database, sql server general, SQL Scripts, sql errors, SQL Server Problems, SQL CLR
-
As a best practice, DBA need to verify each database backups are properly done or not, also make sure the backups are OK then is readable and can be restored. Because so many databases are scheduled as FULL and differential backups weekly/daily and transaction log backups on every hours or whatever as...
Posted to
sqlideas
by
Paresh Prajapati
on
11-16-2011
Filed under:
Filed under: sql, tsql, sql server, ms sql server, t-sql, #SQL Server, mssql, #sql, database, sql server general, SQL Scripts, backup
-
After posting some snaps to configure transactional replication in sql server having publication server as distributor, i want to share some of the issue which i got during working with it. You may also faced the same issue and got resolved as well. You can comment if you faced any other replication...
Posted to
sqlideas
by
Paresh Prajapati
on
11-05-2011
Filed under:
Filed under: sql, tsql, sql server, ms sql, ms sql server, t-sql, #SQL Server, #sql, database, sql server general, Maintenance, SQL Scripts, sql errors, SQL Server Problems, JustLearned, query, Replication
-
Previously i have posted for the overview and usage of the Grouping Sets as how can we get the aggregate data of different group sets with GROPING SETS vs Native method of group by. If you have not read my earlier post for the same then please read it before go ahead with this demonstration. In this...
Posted to
sqlideas
by
Paresh Prajapati
on
11-03-2011
Filed under:
Filed under: sql, sql server 2008, tsql, sql server, ms sql, ms sql server, t-sql, #SQL Server, #sql, database, sql server general, SQL Scripts, SQL new features, Performance
-
Before SQL Server 2008 , when we need gather all information and details related to server or database level, we must run the script individually by connecting each SQL Server instances. But SQL Server 2008 came up and easy our work for that. It has introduced a new feature - Central Management Servers...
Posted to
sqlideas
by
Paresh Prajapati
on
10-26-2011
Filed under:
Filed under: sql server 2008, tsql, sql server, ms sql, ms sql server, t-sql, sql server denali, #SQL Server, #sql, sql server 2011, database, sql server general, enhancements, SQL Scripts, SQL new features
-
Problem: Before a few days ago i have installed SQL Server Denali CTP3 . Then i have querying in query analyzer and found, minimizing result is not working with CTRL+R is not working. Before CTP3 i have already Denali CTP1 installed in my machine and it was working perfectly, So it stopping to work in...
Posted to
sqlideas
by
Paresh Prajapati
on
10-21-2011
Filed under:
Filed under: ms sql, ms sql server, sql server denali, #SQL Server, #sql, database, SQL Server Code Named Denali, Denali, CTP, SQL Server Problems, Download