One of my Jr. Developer always wondered when she creates any Stored Procedure (SP) and if there is incorrect table name in the SP it creates the SP fine but while executing it gives run time error. However, if there is any valid table from database is referenced in SP with incorrect column name it [...]
Previously I wrote about SQL SERVER - 2008 - Introduction to SPARSE Columns. Let us understand the concept of SPARSE column in more detail. I suggest you read the first part before continuing reading this article.
All SPARSE columns are stored as one XML column in database. Let us see some of the advantage and disadvantage [...]
It is very good to know our server and its feature which are available for configurations. SQL Server 2008/2005/2000 always have many feature which can be enabled or disabled. One should atleast know what are the options SQL Server provides.
If advanced settings are not enabled at configuration level SQL Server will not let user change [...]
Here is an oppurtunity for settling in Australia. A 4 year family visa will be done and will also assist you in Perm Resident Visa. This is for major Consulting firm in Austarlaia. All communication...
For more info on latest job openings and other career related information visit my site
One if the great things about doing Fasttrack reviews is getting feedback from ISV’s. We were recently in a review where the ISV was using both SQL Server and MySQL. Of course working for Microsoft my first question was to ask why they had chosen to use MySQL. As expected the reply was because they required a lot of databases and they believed that the freely distributable version of SQL Server
Just a day ago, I noticed ’sysadmin’ user in SQL Server 2008. While looking more into it, I found that it has same account rights as ’sa’ account. ’sysadmin’ is actually replacement for legacy ’sa’ account. ’sa’ still exist in SQL Server 2008, however, it will be deprecated in future versions of SQL Server. It [...]
If you are using SQL Server 2005, following two are very important security updates not to be missed.
Security Update for SQL Server 2005 Service Pack 2 (KB948108)
A security issue has been identified in the SQL Server 2005 Service Pack 2 that could allow an attacker to compromise your system and gain control over it.
Security Update [...]
Standard Software Pvt. Ltd.
699F, Block P, New Alipore,
Kolkata – 700053 INDIA
Off: (033) 24008804/9240
Requirement for Visual Foxpro on SQL Server/ Oracle/ MySQL:
Good Knowledge of Microsoft ArchitectureShould be MCSD/MCAD/MCTS/MCPD WITH 3-4 yrs experience in object Oriented Programming in Visual Foxpro on SQL Server/Oracle/mySQL
I have been writing recently about how SQL Server 2008 is better in terms of Data Stage and Backup Management. I have received very good replies from many users and have requested to write more about it. Today we will look into another interesting concept of SPARSE column. The reason I like this feature because [...]
Sometimes things just go very convenient and we wish that how come it was not available in earlier versions.
Let us see two features here. If it was SQL Server earlier versions we might have to write more lines to achieve what we can achieve in lesser lines. Following small example with only one variable demonstrates [...]
O SQL Server é um sistema de gerenciamento de bancos de dados cliente/servidor de alto desempenho com alta integração com o Windows NT. Apostila completa com mais de 240 paginas de informaçoes no formato Word. [+] Faça veja já as especificações completas do produto![+] Veja os mínimos requisitos para rodar o pr
The SQL 2005 installer expects the installation media to be in a specific layout. If the directory structure is incorrect the error message you receive during setup is: "There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information."
The behavior I saw was that the SQL server itself would install, but the
We have an immediate opening with one of our reputed client "iGATE Global Solutions (www.igate.com) " Bangalore. Given below the job details - iGATE Global Solutions, an SEI CMMI Level 5 Company, is...
For more info on latest job openings and other career related information visit my site
Since SAP more or less supported the usage of VMWare and Hyper-V as Software Virtualization layer for Windows (see SAP OSS note #674851 and ) one question came up more and more. Which is: How do I license Windows and SQL Server in typical SAP scenarios where processor licenses are used? View Full Article: MSDN Blogs
In my previous article SQL SERVER - 2008 - Introduction to New Feature of Backup Compression I wrote about Row Compression and I have received many request to write in detail about Row Compression. I like when I get request about any subject to write about from my readers.
Row Compression feature apply to zeros and [...]
In recent user group meeting in my city Ahmedabad, I have found that not every user knows difference between these two features of SQL Server. I do not blame any user for not knowing difference between Database Mail and SQLMail as this is very confusing sometime. I will try to explain this concept here.
Database mail [...]
I received following email yesterday from Satnam Singh- Computer Programmer from Bangalore.
“Dear Pinal,
Congratulations for being MVP. You truely deserved it.
I wonder why have you never written newly introduced feature of vardecimal.
Keep up good work!
Satnam Sign
Developer - Bangalore.”
In SQL Server 2005 SP2 they have introduced new concept of vardecimal, which reduces the size of
Backup and Data Storage is my most favorite subject and I have not written about this for some time. I was experimenting with new feature of SQL Server 2008 and I come across very interesting feature of Backup compression.
Let us see example of Database AdventureWorks with and without compression. After taking backup with compression enabled [...]
I previously wrote article about SQL SERVER - Insert Multiple Records Using One Insert Statement - Use of UNION ALL. I am glad that in SQL Server 2008 we have new feature which will make our life much more easier. We will be able to insert multiple rows in SQL with using only one SELECT [...]
I am very glad to announce that Microsoft has awarded me Most Valuable Professional Award for SQL Server. I would like to thank Microsoft and MVP Lead Abhishek for awarding this honor to me. MVP is most prestigious award and I am very pleased to receive it. I thank all of my readers for their [...]
After reading my previous article about SQL SERVER - 2008 - High Availability - Hot Add CPU the same developer who suggested Hot Add CPU asked me if there are any restrictions in Hot Adding Memory.
Yes, there are few restictions to Hot Add Memory as well. I am listing them here.
1) Underlying hardware is always [...]
Author: jituacSubject: SQL Server Connection Problem?Posted: 29 Jun 08 at 6:13amHi, I need to run a vb.net application in workgroup.My sql server is installed in XP system,my application is also in same system in a sharing folder.For other system can access the application in sharing folder.But while accessing from other system,sql server is nt connecting.I got security excpetions also,i use
As vezes necessitamos, pesquisar por uma string eventualmente em todas as colunas de uma tabela. Para isso podemos utilizar uma procedure como essa:
CREATE PROCEDURE sp_FindStringInTable @stringToFind VARCHAR(100), @schema sysname, @table sysname
AS
DECLARE @sqlCommand VARCHAR(8000)
DECLARE @where VARCHAR(8000)
DECLARE @columnName sysname
DECLARE @cursor VARCHAR(8000)
BEGIN TRY
SET @sqlComman
One of team member suggested that we should upgrade to SQL Server 2008 because its new feature is very cool “Hot Add CPU”.
Yes, I agree it is very cool feature. I am eagerly waiting for RTM of SQL Server 2008 so I can upgrade our servers to SQL Server 2008. However, to use the feature [...]
What is difference between DBMS and RDBMS?
DBMS - Data Base Management System
RDBMS - Relational Data Base Management System or Relational DBMS
A DBMS has to be persistent, that is it should be accessible when the program created the data ceases to exist or even the application that created the data restarted. A DBMS also has to [...]
At a Glance: Why lock escalation occurs Avoiding unnecessary blocking Optimizing your queries Monitoring the impact of locking on performance Read More: -us/magazine/cc434694(TechNet.10).aspx
I think this is most popular question I receive in email, if I have SQL Server cheatsheet. Well, SQL Server is very wide subject and covering all the main topics of SQL Server will take 100 pages book as cheatsheet. I have tried to create one page cheatsheet which I use for my daily use. [...]
I found one of the Jr. Developer writing trigger for the requirement where he wanted to make sure invalidate data does not enter in table column. I suggested him to write Check Constraint. Check Constraints are very handy to make sure all the data in the table is validated before it enters in the database.
Let [...]
Many times we need to know what is the current identity of the column. I have found one of my developer using aggregated function MAX() to find the current identity.
USE AdventureWorks
GO
SELECT MAX(AddressID)
FROM Person.Address
GO
However, I prefer following DBCC command to figure out current identity.
USE AdventureWorks
GO
DBCC CHECKIDENT (‘Person.Address&
Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, security, developer productivity, business intelligence (BI), and compatibility with the 2007 Microsoft Office System. It achieves this at a considerably lower cost than does Oracle Database 11g.
Included in This Document
* Executive Summary
*
American Company needs Software developers for Kolkata branch Office having 2-5 years of Experience in:
C#, VB.Net, ASP.Net, AJAX, SQL Server 2005 responsible for understanding specifications , designing and developing Software SoloutionsJ2EE , J2ME (Favored), Oracle PL/SQLCandidates having BCA, MCA, BE, BTech or similar qualifications and who can take ownership and pride in their work, who are
I have been playing with SQL Server 2008 recently. There are many new features which SQL Server 2008 have. One of the interesting addition to SQL Server 2008 is system table field which records when SQL Server was started. This field has data type as datetime that is why it is precise to 3 milisecond.
Note [...]
Immediate openings for B.Sc. Freshers also Oracle, PL/SQL & SQL Server and PHP Programmers at Bangalore
Intrested candidates can directly come for the face to face discussion:
Venue:
CRM Consultancy
Universal Business Centre ,
TNR Chambers,
1/A Chruch street,
Brigade Road, (Landmark:opposit to nokia showroom,nasa pub)
Bangalore - 560 001
Mobile: 9741111362
E-mail Resume at: manohar@
SERVERPROPERTY is very interesting system function. It returns many of the system values. I use it very frequently to get different server values like Server Collation, Server Name etc.
Run following script to see all the properties of server.
SELECT ‘BuildClrVersion’ ColumnName, SERVERPROPERTY(‘BuildClrVersion’) ColumnValue
UNION ALL
SELECT ‘Collation’,
I loved this feature. I have always wanted this feature to be present in SQL Server. Last time when I met developers from Microsoft SQL Server, I had talked about this feature. I think this feature saves some time but make the code more readable.
—- SQL Server 2005 Way
DECLARE @MyVar INT
SET @MyVar = 5
SELECT @MyVar
I have previous written article about SQL SERVER Database Coding Standards and Guidelines Complete List Download. I just received question from one of the blog reader is there any way we can just prevent violation of company policy. Well Policy Management can come into handy in this scenario.
If our company policy is to create all [...]
As there are Openings for Wipro Technologies of Project Manager. We are not from consultancy; you will be on direct permanent payrolls of Wipro Technologies. Hence, Go through the job description &...
For more info on latest job openings and other career related information visit my site
REQUIREMENT : 1 .NET APPLICATIONS TEAM LEAD...This position, which will report to the Associate VP, Delivery Management, will be responsible for the development, enhancement and maintenance of...
For more info on latest job openings and other career related information visit my site
The Next Generation: Visual Studio 2008
Take a tour of the new features and functionality in Visual Studio 2008. LINQ to Your SQL Server Data
Build efficient queries using LINQ, which is included in Visual Studio 2008. Debugging and Logging in SSIS
Easily debug packages, Control Flow tasks, and Data Flow tasks as well as log package-execution information using the capabilities in SSIS. SQL
Career opportunity with one of our client, SUPERVALU Bangalore location for the following skill set: SharePoint, C#, .Net and SQL Server with 5+ years of experience.
ABOUT SUPERVALU:
1. Our client...
For more info on latest job openings and other career related information visit my site
Microsoft SQL Server 2008 Reporting Services Add-in for SharePoint Technologies Release Candidate (RC0) (Reporting Services Add-in) enables you to take advantage of SQL Server 2008 Release Candidate (RC0) report processing and management capabilities within Windows SharePoint Services (WSS) 3.0 or Microsoft Office SharePoint Server 2007. The download provides the following functionality:
A Report
Microsoft made available to select testers on June 5 the near-final Release Candidate (RC) 0 of SQL Server 2008. As of Friday, Microsoft had released the latest test build of its database to TechNet Plus and Microsoft Developer Network(MSDN) subscribers only. The new build wasn’t on the private Connect test site. (Not sure if availability has changed since then.) Microsoft officially “laun
Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback. SQL Server 2008 provides a comprehensive data platform that is secure, reliable, [...]
USA-s toimuva TechEd 2008 ajal, nagu ikka, annab Microsoft välja oma toodete uusi versioone. Viimase nädala jooksul on Microsoft toonud häid sõnumeid andmebaaside, Silverlight’i ja SharePoint’i arendajatele.
SQL Server 2008 RC0
SQL Server 2008 väga esimene release candidate, mis kannab millegi pärast numbrit 0, on kättesaadav kõigile MSDN’i ja TechNet’iga liitunud
I previously wrote two articles about PIVOT and UNPIVOT tables. I really enjoyed writing about them as it was interesting concept. One of the Jr. DBA at my organization asked me following question.
“If we PIVOT any table and UNPIVOT that table do we get our original table?”
I really think this is good question. Answers is [...]
I represent an executive search firm in Bangalore. Let us know if you would be open to considering a Career /Working with one of our client Alcatel Lucent in Bangalore
Qualification: BE/ B.Tech,...
For more info on latest job openings and other career related information visit my site
Configuration SettingsThis article describes the following configuration settings and considerations for their use: • Affinity Mask• Lightweight Pooling• Max Async IO• Max Worker Threads• Memory• Priority Boost• Set Working Set SizeSQL Server can obtain a very high level of performance with relatively little configuration tuning. You can obtain high levels of performance by using goo
One of the trickiest things about learning SQL is mastering how various JOIN statements differ in the ways they combine data from multiple data tables. There are three types of joins: inner, outer, and cross. In addition, there are three types of outer joins: left, right, and full. It can be frustrating trying to keep them differentiated, so here's a quick guide. All of the following examples invo
PROGRAMMERS VB.Net +SQL Server + Crystal Reports for a fast growing packeged Software Company.
Offers extremely competitive salary, performance bonus, and growth opportunities.
Min. Experience 3 years.
Walk-In Interviews from 6th June, 2008 at:
601, Ansal Majestic Tower, Vikas Puri,
New Delhi - 110018.
Phone: 45610880
or Send your resume to : hr@optsoft.in
SQL SERVER 2008 has introduced new concept of Compound Assignment Operators. Compound Assignment Operators are available in many other programming languages for quite some time. Compound Assignment Operators is operator where variables are operated upon and assigned on the same line.
Let us see following operation without using Compound Assignment Operators.
DECLARE &#
PROJECT SUMMARY: The role of senior Software Engineer is to read and understand software requirements and to develop software solutions based on those requirements. The Programmer/Analyst position is...
For more info on latest job openings and other career related information visit my site
I received following question in email :
How to create a comma delimited list using SELECT clause from table column?
Answer is to run following script.
USE AdventureWorks
GO
DECLARE @listStr VARCHAR(MAX)
SELECT @listStr = COALESCE(@listStr+‘,’ ,”) + Name
FROM Production.Product
SELECT @listStr
GO
I have previously written similar [...]
Acronis Recovery for MS SQL Server is a cutting-edge, reliable, and cost-effective backup and recovery tool for MS SQL databases. With this comprehensive solution, you can restore your databases in case of any unforeseen event.Backing up only data in your databases is not enough, since they include tables, logs and other components that structure the data. Acronis provides you with a smart utility
Just a day ago, I was was asked this question in one of the teaching session to my team members. One of the member asked me if I can use DISTINCT in Aggregate Function and does it make any difference.
Of course! It does make difference. DISTINCT can be used to return unique rows from a [...]
I just found one of my Jr. DBA to create many indexes with lots of column in it. After talking with him I found out that he really does not understand how really Index works. He was under impression that if he has more columns in one index, that index has higher chance of getting [...]
Database administrators in enterprises today face the challenging task of determining an appropriate physical design that consists of partitioned tables, indexes, and indexed views and that both optimizes server performance and is easy to manage. Database Engine Tuning Advisor (DTA) in Microsoft SQL Server 2005 can assist in this task. Given a workload of SQL queries and updates, DTA recommends an
Osprosys Software (P) Ltd.: Osprosys is a global management consulting, technology services and outsourcing company, which is a US base IT company. We have 3 branch offices in US and 1 offshore...
For more info on latest job openings and other career related information visit my site
I have been asked many times when there is DATENAME function available why do I go in exercise of writing UDF For the getting the day of the week. Answer is : I just like it!
SELECT DATENAME(dw, GETDATE())
Reference : Pinal Dave ()
Very frequently Jr. Developers request script for creating default constraint over table column. I have written following small script for creating default constraint. I think this will be useful to many other developers who want this script to keep handy.
ALTER TABLE Customers
ADD CONSTRAINT DF_Customers_A
Empresa localizada em Moema com foco em E-Learning precisa de profissional de TI, de preferencia com essas qualidades:- ASP- SQL Server 2005- IIS- Javascript- AJAX- HTML com CSS (tableless ou não tudo precisa ser compativel com IE e Firefox)- Ferramentas de streaming de vídeo- Windows media servicesRemuneração e benefícios serão combinados.O profissional deve ser pró-ativo e flexivel para f
New Types of Replication in SQL Server 2005 Heterogeneous Replication New types of replications have been introduced in SQL Server 2005. The first of these is the Heterogeneous Replication which allows the publication of data from heterogeneous subscribers such as Oracle, DB2 using relevant ODBC drive and OLE DB provider. In SQL Server 2005 allows configuration of the snapshot and transaction re
Index Rebuilds in SQL Server 2000 vs SQL Server 2005Below outlines the index rebuilding code changes from SQL Server 2000 to 2005 with the purpose of the code and a sample. SQL Server 2000 SQL Server 2005 CREATE INDEX with DROP_EXISTING - Creates a new index with the same name and drops the current index while ensuring the nonclustered indexes are not rebui
Job Title : SQL Server 2000/20005 DBALocation : West De Moines, Denver/WDMMinimum Experience : 6 plus YearsMust Have Skills:Must have SQL Server experienceWindows and UNIX platform experience a must, especially AIX and LinuxExperience in logical and physical data modelling.Knowledge of the differences in SQL syntax for: DB2, Oracle, SQL ServerKnowledge of database DDL and DML migrationsExperience
My previous article SQL SERVER - PIVOT Table Example encouraged few of my readers to ask me question about UNPIVOT table. UNPIVOT table is reverse of PIVOT Table.
USE AdventureWorks
GO
CREATE TABLE #Pvt ([CA] INT NOT NULL,
[AZ] INT NOT NULL,
Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing between databases to maintain consistency. Using replication, you can distribute data to different locations and to remote or mobile users over local and wide area networks, dial-up connections, wireless connections, and the Internet. Replication Types
This download comes as a pre-configured VHD. This download enables testing of application designs on the Windows Server Platform.
As design gets more closely integrated into the process of building websites and web applications it becomes more critical to have all the necessary software installed on your machine to enable you to preview and review the [...]
Datetime functions and stored procedures always interests me. Nanda Kumar has suggested modification to previous written article about SQL SERVER - SQL SERVER - UDF - Get the Day of the Week Function - Part 2. He has improved on UDF.
CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME)
RETURNS VARCHAR(10)
AS
Just a day ago, we faced situation where one column in database contained two values which were separated by comma. We wanted to separate this two values in their own columns. It was interesting that value of the column was variable and something dynamic needed to be written.
Following is quick script which separates one column [...]
SQL Server Fixed Database-Level Roles Fixed database roles are defined at the database level and exist in each database. Members of the db_owner and db_securityadmin database roles can manage fixed database role membership; however, only members of the db_owner database role can add members to the db_owner fixed database role. The fixed database roles are the following: *
SQL Server 2005 Server-Level Fixed Roles Fixed server roles are server-wide in their scope. Each member of a fixed server role can add other logins to that same role The fixed server roles are: * bulkadmin * dbcreator * diskadmin * processadmin * securityadmin * serveradmin * setupadmin * sysadmin bulkadminMembers of the bulkadmin fixed server rol
Um dos grandes problemas de usar SQL Server em hospedagens é a necessidade de pagar uma graninha extra por isso, o que ninguém quer.
Na versão SQL Server 2005 surgiu a possibilidade de inserir o banco .MDF na pastinha app_data, mas isso não é nada bom : O servidor ainda é absolutamente necessário e uma instância do [...]
I like to help every candidate who are finding job. I have previously written article here which can help all the people who are looking for job or looking for candidates.
SQL Server Interview Questions and Answers Complete List Download
Find Job Related to SQL SERVER
SQL Server DBA- Job Description
I have written article about SQL SERVER - UDF - Get the Day of the Week Function. I have received good modified script from reader Mihir Popat has suggested another code where Sunday does not have to be necessary the first day of the week.
CREATE FUNCTION dbo.udf_DayOfWeek(@dtDate DATETIME)
RETURNS VARCHAR(10)
&
This is quite a popular question and I have never wrote about this on my blog. A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, [...]
SQL Server 2008 contains a new feature designed to help troubleshoot particularly tricky connectivity problems. This new feature, the Connectivity Ring Buffer, captures a record for each server-initiated connection closure, including each kill of a session or Login Failed event. To facilitate efficient troubleshooting, the ring buffer attempts to provide information to correlate between the client
Minimum 2 years ASP.NET & C# development using Visual StudioProficient in programming in web technologies such as AJAX, XML, JavascriptHeavy experience with SQL Server 2005 databasesExperience with SQL Server stored procs & triggersProficient with writing and understanding complex SQLAbility to provide multiple options and recommendations for implementing specific requirementsAbility to wo
Silicon Interfaces offers on-site contract services and offshore turnkey projects development at our development centers. It has two main areas of activities, - Software and...
For more info on latest job openings and other career related information visit my site
we have some exclusive requirements with our esteemed client TESCO (India). We have this URGENT requirement for Managers with below mentioned qualities. Note : This position will be directly...
For more info on latest job openings and other career related information visit my site
This is quite a popular question and I have never wrote about this on my blog. A Pivot Table can automatically sort, count, and total the data stored in one table or spreadsheet and create a second table displaying the summarized data. The PIVOT operator turns the values of a specified column into column names, [...]
I recently came across very nice article about optimization tips for SQL Server 2005. Here is the list of those 12 tips.
Twelve Tips For Optimizing Sql Server 2005 Query Performance
1. Turn on the execution plan, and statistics
2. Use Clustered Indexes
3. Use Indexed Views
4. Use Covering Indexes
5. Keep your clustered index small.
6. Avoid cursors
7. Archive old [...]
Enterprise
SQL Server 2008 is a comprehensive data platform that meets the high demands of enterprise online transaction processing and data warehousing applications.
Standard
SQL Server 2008 Standard is a complete data management and business intelligence platform providing best-in-class ease of use and manageability for running departmental applications.
Workgroup
Run branch locations on this re
I have previously written article about SQLAuthority News - Job Description of Database Administrator (DBA) or Database Developer. I have received quite a lot of request to update it or post something similar. Writing SQL Articles are easier then writing Job description for DBA. I have read many job description and job posting at Best [...]
Just a day ago, while installing SQL Server on our development machine Jr. DBA asked me what should be kept file growth of the TempDB. I really have not thought about this till moment and I looked at MS site.
I found following answer and I think it is quite interesting.
tempdb file size - FILEGROWTH increment [...]
Q. What is CTE (Common Table Expression)?Ans: CTE is a temporary Table created from a simple SQL query. You can say it’s a view. Below is a sample CTE created “PurchaseOrderHeaderCTE” from “PurchaseOrderHearder” With PurchaseOrderHeaderCTE (Orderdate, status) As(SELECT order date, statusFROM Purchasing.PurchasingOrderheader ) SELECT * FROM PurchasingOrderheader The WITH Statement defin
1. What is database? A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and populated with data for a specific purpose. 2. What is DBMS? It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users with
Databases are the heart and soul of many of the recent enterprise applications and it is very essential to pay special attention to database programming. I’ve seen in many occasions where database programming is overlooked, thinking that it’s something easy and can be done by anyone. This is wrong. For a better performing database you need a real DBA and a specialist database programmer, let i
1. Check OS Event Logs, SQL Server Logs, and Security Logs for unusual events.2. Verify that all scheduled jobs have run successfully.3. Confirm that backups have been made and successfully saved to a secure location.4. Monitor disk space to ensure your SQL Servers won’t run out of disk space.5. Throughout the day, periodically monitor performance using both System Monitor and Profiler.6. Use En
• What is a DDL, DML, DCL, TCL and DSPL concept in RDBMS world?The Data Definition Language (DDL) includes, CREATE TABLE - creates new database tableALTER TABLE - alters or changes the database tableDROP TABLE - deletes the database tableCREATE INDEX - creates an index or used as a search keyDROP INDEX - deletes an index The Data Manipulation Language (DML) includes, SELECT - extracts data
Step 1: Create the database mail profile account using SQL Server Management Studio. Give the profile name to “FreeSpaceAlertMails” Step2: Create the below procedure in master database which will check the disk space. CREATE PROCEDURE sendAlertMailsASBEGINSET NOCOUNT ONDECLARE @availableSpace AS FLOATDECLARE @alertMessage AS Varchar(4000) CREATE TABLE #tbldiskSpace(driveName VARCHAR(3),f
We can’t read the transaction logs directly from SQL Server. Some products do allow you to read the logs, such as: * Apex SQL Log (Works with MSSQL2000 and MSSQL2005)* Log Explorer* SQL Log Rescue (Only work with the SQL Server 2000) The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005 DBCC LOG([,{0|1|2|3|4}]) 0 - Basic Log Information (default)1 - L
We can’t read the transaction logs directly from SQL Server. Some products do allow you to read the logs, such as: * Apex SQL Log (Works with MSSQL2000 and MSSQL2005)* Log Explorer* SQL Log Rescue (Only work with the SQL Server 2000) The below undocumented DBCC command is working in both SQL Server 2000 & SQL Server 2005 DBCC LOG([,{0|1|2|3|4}]) 0 - Basic Log Information (default)1 - L
