In molti sanno che Microsoft da qualche anno a questa parte distribuisce alcuni suoi prodotti in versione Express cioè liberi da qualsiasi costo di licenza. Tra questi prodotti troviamo le ultime due versioni di Visual Studio: 2005 e 2008, o le versioni Sql Server 2005 Express e Sql Server 2008 Express. Questi prodotti come è facile intuire presentano però delle limitazioni. Per ese
Few days ago, I have wrote about SQL SERVER - DISABLE and ENABLE user SA I received following email from one of the user who received following error.
Msg 15151, Level 16, State 1, Line 2
Cannot alter the login ’sa’, because it does not exist or you do not have permission.
Fix/Workaround/Solution:
This error had occurred because of [...]
Just a day ago, I received question from blog reader Mike McDonald.
“How can I modify permissions for SA user? I tried to modify dbo users permission but now I am having problems.”
First of all, there may be no relation between dbo user and SA user. They are different and should be left separate.
Modifying the permission [...]
It is quite common myth that SQL Server 2008 Developer Edition is FREE.
SQL Server 2008 developer edition has same code base and same features which are available in SQL Server 2008 enterprise edition. Only difference between them is licensing terms. Developer Edition can not be used in production environment and it can be used on [...]
I often receive good question on blog, however, I do not always receive good answer for the questions. Imran Mohammed is one SQL Expert who spend his time helping SQL Community on this blog. I always read his answers as there is something to learn everytime. Recently someone asked on blog about Finding next run [...]
Feature Pack for SQL Server 2005 December 2008
Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005.
Microsoft SQL Server Protocol Documentation
The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and
Just a day before I wrote about SQL SERVER - Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so.
Let us see following example.
USE AdventureWorks
GO
/* Create Test Table */
CREATE TABLE TestTable (FirstCol VARCHAR(10))
GO
/* Check Database Column
Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The December 2008 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to “New and Updated Books Online Topics” for [...]
Service Pack 3 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP3. You can use these packages to upgrade any of the following SQL Server 2005 editions:
Enterprise
Enterprise Evaluation
Developer
Standard
Workgroup
Download Service Pack 3 for Microsoft SQL Server [...]
I really enjoyed users participation in my previous question. Read SQL SERVER - Interesting Interview Questions before continuing reading this article. This interview question was about user participation and about how good and how different you can come with your T-SQL script. What I really liked is that many users took this test seriously and [...]
Today we will go over very quick tip about finding out collation of database and table column. Collations specify the rules for how strings of character data are sorted and compared, based on the norms of particular languages and locales
Today’s script are self explainary so I will not explain it much.
/* Find Collation of SQL Server Database */
SELECT DATABASEPROPERTYEX(‘Advent
I received following email from Mike Bikkins.
“How can I connect to SQL Server 2005 or SQL Server 2008 using SQL Server 2000’s Enterprise Manager?”
No. You can not connect with SQL Server 2005 and higher version using Enterprise Manager. You will need SQL Server Management Studio available with SQL Server 2005 and higher version.
Reference : Pinal [...]
Few days ago, I received wonderful email from blog reader and it was like good puzzle. I enjoyed solving this puzzle. I did not write the name of the blog reader because I am not sure if he wants his name here or not. Please read this article and run the script described in email. [...]
Yesterday we looked at Puzzle and I did got great response to this question. Very interestingly not many got it right. First go through the puzzle first and then come back here and read answer.
Read Original Interview Question and Puzzle.
Question: Select all the person from table PersonColor who have same color as ColorCode or have [...]
This 490-page document covers the essential phases and steps to upgrade existing instances of SQL Server 2000 and 2005 to SQL Server 2008 by using best practices. These include preparation tasks, upgrade tasks, and post-upgrade tasks. It is intended to be a supplement to SQL Server 2008 Books Online.
A successful upgrade to SQL Server 2008 [...]
In the recent time of recession my company is able to continue its progress and we are hiring. It is very surprising to me that many developers who have experience with SQL Server could not get following simple question right. There were nearly 40 candidates I interviewed but none of the candidate was able to [...]
Please send your profiles to saikrishna.chiranjeevi@droisys.com We have a Client hot requirement in Downtown Dallas, TX if you have any consultants for below requirement, Please Send the resumes/Rate and contact details. I really appreciate for your time and help v Role: Sr. SQL Server DBA that has expertise with Replication and SAN experience Location: Downtown Dallas, TX
When installing service pack 2 for SQL 2005, sometimes a bug presents itself where the installer needs access to some files that are inside the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA folder. The bug is that these files do not have the correct permissions set. Even the Administrator does not have permission on these files. If you set the permissions for the data folder to th
Author: JijoSubject: Access/SQL Query Question-Find Newest RecordPosted: 22 Nov 08 at 6:05pmI think u can do this in a better way. But for that u need a primary key for this table. Or a field with a unique Id. What i would do is add a new field DWGS.Id which is an autonumber. Then i would find the Id of the record with the criteria u specified select top 1 Id from tablename where D
I love active participation from my readers. Just a day ago I wrote article about SQL SERVER - Simple Use of Cursor to Print All Stored Procedures of Database. I just received comment from Jerry Hung who have improved on previously written article of generating text of Stored Procedure.
DECLARE @procName VARCHAR(100)
DECLARE @getprocName CURSOR
SET @getprocName = CURSOR FOR
SELECT [...]
Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was [...]
SQLAuthority Blog reader YordanGeorgiev has submitted very interesting SP, which uses cursor to generate text of all the Stored Procedure of current Database. This task can be done many ways, however, this is also interesting method.
USE AdventureWorks
GO
DECLARE @procName VARCHAR(100)
DECLARE @getprocName CURSOR
SET @getprocName = CURSOR FOR
SELECT s.name
FROM sysobjects s
WHERE type = ‘
Author: msmith974Subject: Access/SQL Query Question-Find Newest RecordPosted: 19 Nov 08 at 7:00pmHello,I have an access database application with the following table & fields that I would like to query: Table Name: DWGSFields: DWGS.Discipline, DWGS.Area/Bldg, DWGS.DWGS, DWGS.DWG Number, DWGS.DWG Title, DWGS.DWG Rev Number, DWGS.Issued, DWGS.Date EnteredThe data types of all fields are Text Fie
Esto es noticia vieja ya, pero es algo que me preguntan mucho, me preguntan donde pueden bajar el SP2 de SQL Server 2005. Lo pueden encontrar en: Post relacionado: -server-2005-service-pack-2.aspx
The RML utilities allow you to process SQL Server trace files and view reports showing how SQL Server is performing. For example, you can quickly see:
Which application, database or login is using the most resources, and which queries are responsible for that
Whether there were any plan changes for a batch during the time when the [...]
SQL Server stores history of all the taken backup forever. History of all the backup is stored in msdb database. Many times older history is no more required. Following Stored Procedure can be executed with parameter which takes days of history to keep. In following example 30 is passed to keep history of month.
USE msdb
GO
DECLARE [...]
Today we will see quick script which will check integrity of all the database of SQL Server.
EXEC sp_msforeachdb ‘DBCC CHECKDB(”?”)’
Above script will return you lots of messages in resultset. If there are any errors in resultset they will be displayed in red text. If everything is black text there is no error. Typical output of [...]
It was not possible to connect SQL Server 2008 to Visual Studio 2005 so far. Microsoft has released Service Pack once it is installed SQL Server 2008 can be connected to Visual Studio 2005.
Download Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support
For connecting SQL Server 2008 to Visual Studio [...]
Yesterday I received following questions on blog. Ashish Agarwal asked following question.
Hi Pinal,
Can we refresh a database (like we do by right clicking database node in object explorer and clicking on refresh) thru SQL Query?
If yes, can you please tell me the query?
Thanks,
Ashish Agarwal
Answer to above question is NO. It is not possible to do [...]
When allowing SQL traffic to flow across an ISA server its good to know what the ports it uses are for. SQL primarily uses two ports: 1433 (the default sql port) and 1434 (the sql browser service’s port). If you specify that you want to connect to a named instance then the traffic will first be sent over port 1434 to the sql browser service. Then the sql browser service will send back the p
When allowing SQL traffic to flow across an ISA server its good to know what the ports it uses are for. SQL primarily uses two ports: 1433 (the default sql port) and 1434 (the sql browser service’s port). If you specify that you want to connect to a named instance then the traffic will first be sent over port 1434 to the sql browser service. Then the sql browser service will send back the p
I just received following screen shot from one of the regular reader of SQLAuthority.com blog. He pointed out important milestone for our blog. We have crossed 5 millions visitors. In less than 2 years SQLAuthority.com blog has been visited by 5 millions visitors. I even missed the anniversary our blog. On November 1st 2008 SQLAuthority.com [...]
Quite often it happens that SQL Server Management Studio’s Dropdown box is cluttered with many different SQL Server’s name. Sometime it contains the name of the server which does not exist or developer does not have access to it. It is very easy to clean the list and start over.
Delete mru.dat file from following location.
For [...]
I have received following question nearly 10 times in last week though emails. Many users have received following error while connecting to the database. This error happens when database is dropped for which is default for some of the database user. When user try to login and their default database is dropped following error shows [...]
Microsoft has published following three security related white papers. I suggest to all my readers to read them. Read the summary know what is covered in those white papers.
Engine Separation of Duties for the Application Developer - Separation of duties is an important consideration for databases and database applications. By properly defining schemas and roles, [...]
Recently I have got two desktop computers at home and both of them are very powerful machine.
Machine 1 : Windows Vista SP1 with SQL Server 2008
Machine 2 : Windows 2003 with SQL Server 2005 with SP2
When I was trying to connect from SQL Server 2008 to SQL Server 2005 using Windows Authentication I was getting [...]
There is a known issue with SQL Server 2005 SP2 that occurs if you have moved the system databases to another location. Specifically, the mymssqlsystemresource database. If the mymssqlsystemresource transaction log has been moved from its default location, the installer for SP2 does not recognize this. The installer places the new mymssqlsystemresource.ldf file in the same directory as the mymssq
Stored Procedures are very important and most of the business logic of my applications are always coded in Stored Procedures. Sometime it is necessary to hide the business logic from end user due to security reasons or any other reason. Keyword WITH ENCRYPTION is used to encrypt the text of the Stored Procedure. One SP [...]
Just a day ago, while I was enjoying mini vacation during festival of Diwali I met one of the .NET developer who is big fan of Oracle. While discussing he suggested that he wished SQL Server should have feature where multiple variable can be declared in one statement. I requested him to not judge wonderful [...]
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 to discover SQL Server 2000, 2005 and 2008 installations and components and to monitor them, primarily from the perspective of availability and performance. The availability and performance monitoring is done using a combination of scripts and native Operations Manager capabilities.
Feature Bullet Summary:
The fo
---------- Forwarded message ----------
From: DBADB2sql@surlin.com <DBADB2sql@surlin.com>
Date: Oct 25, 2008 1:46 PM
Subject: Huge - DBA- DB2 Unix or linux with DB2 RDBMS architecture 4+ yrs...
[[ This is a content summary only. Visit my website for full links, other content, and more! ]]
As a Developer, you would come across a scenario where you would want SQL Server to return DateTime in a particular format to the front end. You can use SQL Server’s built in function GETDATE() to return the current DateTime. But if you need a universal date/time, use the built-in function GETUTCDATE(). SQL Server provides [...]
I have seen developer confused many times when they receive following error message.
Msg 325, Level 15, State 1, Line 7
Incorrect syntax near . You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.
The reason for this error is [...]
This article is inspired from two sources.
1) My year old article - SQL SERVER - Effect of TRANSACTION on Local Variable - After ROLLBACK and After COMMIT
2) Discussion with SQL Server MVP - Jacob Sebastian - SQLAuthority News - Author Visit - SQL Hour at Patni Computer Systems
I usually summarize my article at the end, [...]
MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation is the perfect study guide to help you pass the 70-229 exam, which is an elective for the MCSD, MCAD, MCDBA, and MCSE programs. If you are preparing for this exam, you'll find our Training Guide to be the most effective self-study tool in the market! This book is your one-stop shop because of its teaching me
CLR is abbreviation of Common Language Runtime. In SQL Server 2005 and later version of it database objects can be created which are created in CLR. Stored Procedures, Functions, Triggers can be coded in CLR. CLR is faster than T-SQL in many cases. CLR is mainly used to accomplish task which are not possible by [...]
A year ago I wrote post about SQL SERVER - Retrieve - Select Only Date Part From DateTime - Best Practice where I have discussed two different methods of getting datepart from datetime.
Method 1:
SELECT DATEADD(D, 0, DATEDIFF(D, 0, GETDATE()))
Method 2:
SELECT CONVERT(VARCHAR(10),GETDATE(),111)
I have summarized my post suggesting that either method works fine and I prefer to [...]
I really enjoy answering questions which I receive from either comments or Email. My passion is shared by SQL Server Expert Imran Mohammed. He frequently SQL community members by answering their questions frequently and promptly.
Sachin Asked:
Following is my scenario,
Suppose Table 1 and Table 2 has same column e.g. Column1
Following is the query,
1. Select column1,column2 From [...]
Today I am writing on the topic which I do not like to write much. I enjoy writing usually positive or affirmative posts. Recently I got email from two different DBA where they upgraded to SQL Server 2005 trial version on their production server and now as their trial version was expire they wanted to [...]
Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. Its primary query language is Transact-SQL with it's most popular version Sql server 2005.
You can determine what version SQL Server is running by running:
Select @@version (Where @@Version is a system level variable that holds the current version).
How do I restict clients by IP Address?
As the SQL
Continuando o assunto de ontem, vou colocar aqui um exemplo de utilização de envio de email no SQL Server, aproveitando o artigo de backup com compactação de ontem, vou criar aqui um passo dentro do job de backup criado anteriormente, esse passo será executado caso algum passo anterior não funcione e a sua função será enviar uma mensagem ao administrador em caso de erro, informando em qua
After reading my article SQL SERVER - 2008 - TRIM() Function - User Defined Function, I have received email and comments where user are asking if it is possible to remove trailing spaces, leading spaces, white space, tabs, carriage returns, line feeds etc.
I found following script posted by Russ and Erik. It is modified a [...]
Dessa vez resolvi escrever alguma coisa para os famosos “Hard users”, tenho escrito muito sobre o MAC OS e suas distribuições para o PC, testes e respondendo a questões dos leitores. Então resolvi variar um pouco e escrever sobre SQL Server, algumas dicas para os companheiros de profissão.Os passos a seguir descrevem como criar jobs de backup no SQL Server com compactação (arquivo ZIP).
I keep needing to go off and search for this, so as a note to myself, here's the required SQL to find out where tables and columns are referenced in SQL Server stored procedures.select * from information_schema.routines where routine_definition like '%tablename%'I believe this only searches the first 4000 characters of the stored procedure, but this has generally been enough for my needs.
I just received following question in email by James Louren.
“How come SQL Server 2000, 2005 does not have function TRIM()? Is there any way to get similar results.
What about SQL Server 2008?”
James has asked very interesting question. I have previously wrote about SQL SERVER - TRIM() Function - UDF TRIM(). Today my answer is no [...]
What is SQL Server 2000?SQL Server 2000 is an RDBMS that uses Transact-SQL to send requests between a client computer and a SQL Server 2000 computer. An RDBMS includes databases, the database engine, and the applications necessary to manage the data and the components of the RDBMS. The RDBMS organizes data into related rows and columns within the database. What language is commonly used to work wi
• If I want to see what fields a table is made of, and what the sizes of the fields are, what option do I have to look for?• What is a query?• A SQL query is typed in the _________ .• What is the purpose of the model database?• What is the purpose of the master database?• What is the purpose of the tempdb database?• What is the purpose of the USE command?• If you delete a table in
I have received many emails requesting information about SQL Server certifications examples. Microsoft has released new set of exams for SQL Server 2008 certifications. I am listing them here for quick reference.
Exam 70-432 - TS: Microsoft SQL Server 2008, Implementation and Maintenance
Installing and Configuring SQL Server 2008 (10 percent)
Maintaining SQL Server Instances (13 percent)
Managing
Recently I came across two very interesting ‘objects’ of SQL Server 2008.
SQL Server 2008 High Resolution Wallpaper (click on image to see larger version)
SQL Server 2008 Screen Saver
Click Here to Download
Reference : Pinal Dave ()
I recently came across two interesting blog post by PSS SQL Server Engineers. They have written two interesting SQL Server 2008 related post and it can be very helpful to those who come across the issues mentioned in them.
How to Rebuild System Databases in SQL Server 2008
Rarely but sometime there is need to rebuilding the [...]
I previously wrote article SQL SERVER - 2008 - Fix Connection Error with Visual Studio 2008 - Server Version is not supported where I discussed how downloading Visual Studio SP1 will fix the error of Visual Studio 2008 connecting to SQL Server 2008. I have provided link to SP1 which was downloading only installer and [...]
It is very often I get query that how to find if any index is being used in database or not. If any database has many indexes and not all indexes are used it can adversely affect performance. If number of index is higher it reduces the INSERT / UPDATE / DELETE operation but increase [...]
Very frequently I have been asked to create a page, post or article where in one page all the important concepts of SQL Server are covered. SQL Server 2008 is very large subject and can not be even covered 1000 of pages. In daily life of DBA there are few commands very frequently used and [...]
Transforming rows to columns (PIVOT/CROSS TAB) and columns to rows (UNPIVOT) may be one of the common requirements that all of us must have seen several times in our programming life. SQL Server 2005 introduced two new operators: PIVOT and UNPIVOT that made writing cross-tab queries easier.
My friend and SQL Server MVP Jacob Sebastian has [...]
Just a day before I wrote article SQL SERVER - Puzzle - Computed Columns Datatype Explanation
which was inspired by SQL Server MVP Jacob Sebastian. I suggest that before continuing this article read original puzzle question SQL SERVER - Puzzle - Computed Columns Datatype Explanation.
The question was if computed column was of datatype TINYINT how to [...]
I have written many articles about renaming a tables, columns and procedures SQL SERVER - How to Rename a Column Name or Table Name, here I found something interesting about renaming the stored procedures and felt like sharing it with you all.
The interesting fact is that when we rename a stored procedure using SP_Rename command, the [...]
About Company : IPsoft, formed in 1998, is a leading managed services provider, offering a complete solution to enterprise customers for outsourcing global Internet operations. We deploy, manage, secure, scale, and monitor e-business systems using our unique automation technology, which automates functions otherwise done manually, delivering higher quality, cost savings, and increased flexibility
Yesterday I wrote post about SQL SERVER - Get Answer in Float When Dividing of Two Integer. I received excellent comment from SQL Server MVP Jacob Sebastian. Jacob has clearified the concept which I was trying to convey. He is famous for his “behind the scene insight“.
When I read his comment, I realize another interesting [...]
SQL Server 2008 enables you to consume your data within custom applications developed using Microsoft .NET and Visual Studio and within your service-oriented architecture (SOA) and business process through Microsoft BizTalk Server while information workers can access data directly in the tools they use every day, such as the 2007 Microsoft Office system. SQL Server 2008 delivers a trusted, product
SQL SERVER - Guidelines and Coding Standards complete List Download
Coding standards and guidelines are very important for any developer on the path of successful career. A coding standard is a set of guidelines, rules and regulations on how to write code. Coding standards should be flexible enough or should take care of the situation where [...]
CREATE PROCEDURE MyMarriage
@BrideGroom Char(NotBad),
@Bride Char(Good)
AS
SELECT Bride FROM
Brides
WHERE
FatherInLaw = ‘Millionaire’ AND
CarCount > 2 AND
HouseStatus =’TwoStoreyed’ AND
BrideEduStatus=’PGorAbove’
HavingBrothers=’NO’ AND
HavingSisters =’No’ AND
AllowRelocate =’YESR
To express apostrophe within a string, nest single quotes (two single quotes).
Example:
SET @sExample = ‘SQL’’s Authority’
When working with branch conditions or complicated expressions, use parenthesis to increase readability.
IF ((SELECT 1
FROM TableName
WHERE 1=2) ISNULL)
To mark single line as comment use (–) before statement. To mark section of code as comme
Use “Pascal” notation for SQL server Objects Like Tables, Views, Stored Procedures. Also tables and views should have ending “s”.
Example:
UserDetails
Emails
If you have big subset of table group than it makes sense to give prefix for this table group. Prefix should be separated by _.
Example:
Page_ UserDetails
Page_ Emails
Use following naming convention for Stored [.
While attending conference SQLAuthority Author Visit - Microsoft Student Partner Conference, some developers informed me that SQL SERVER 2008 cannot be connected to Visual Studio 2008 and error displays as MS does not support SQL Server version. I was surprised initially as I could not believe that two MS products are not compatible. When trying myself [...]
E' possibile previa registrazione scaricare il libro Introducing Microsoft SQL Server 2008 in formato pdf. Questi i capitoli: Chapter 1: Security and Administration Chapter 2: Performance Chapter 3: Type System Chapter 4: Programmability Chapter 5: Storage Chapter 6: Enhancements for High Availability Chapter 7: Business Intelligence Enhancements
Download SQL Server 2008 Interview Questions and Answers Complete List
Interview is very important event for any person. A good interview leads to good career if candidate is willing to learn. I always enjoy interview questions and answers series. This is my very humble attempt to write SQL Server 2008 interview questions and answers. SQL Server [...]
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
What is Data Compression?
In SQL SERVE 2008 Data Compression comes in two flavors:
Row Compression
Page Compression
Row Compression
Row compression changes the format of physical storage of data. It minimize the metadata (column information, length, offsets etc) associated with each record. Numeric data types and [...]
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
How can we rewrite sub-queries into simple select statements or with joins?
Yes we can write using Common Table Expression (CTE). A Common Table Expression (CTE) is an expression that can be thought of as a temporary result set which is defined within the execution [...]
1. What does integration of .NET Framework mean for SQL Server 2005?This feature enables us to execute C# or VB.NET code in the DBMS to take advantage of the .NET functionality. This feature gives more flexibility in writing complex stored procedures, functions, and triggers that can be written in .net compatible language.2. What is SSIS?According to Microsoft SQL Server Integration Services
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
3) Questions of SQL SERVER 2008
What are the basic functions for master, msdb, model, tempdb and resource databases?
The master database holds information for all databases located on the SQL Server instance and is theglue that holds the engine together. Because SQL Server cannot start [...]
Write a SP to SEARCH Field name in a Database in sql server 2005?To run the SP/*findColumnInfo 'cat'*/create procedure findColumnInfo( @colInfo varchar(100))asbeginSELECT table_name = sysobjects.name, column_name = syscolumns.name, datatype = systypes.name, length = syscolumns.lengthFROM sysobjects JOIN syscolumns ON sysobjects.id = syscolumns.idJOIN systypes
How to Rename a Database Name in Sql Server 2005?Here is the sample code to do it.for 2005,2000 versionsEXEC SP_RENAMEDB 'oldDB name', 'newDB name'Supported in SQL Server 2005+ ALTER DATABASE "oldDB name" MODIFY NAME="newDB name"
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
What command do we use to rename a db, a table and a column?
To rename db
sp_renamedb ‘oldname’ , ‘newname’
If someone is using db it will not accept sp_renmaedb. In that case first bring db to single user using sp_dboptions. Use sp_renamedb to rename database. [...]
Paperback: 408 pagesPublisher: Apress (September 21, 2007)Language: EnglishISBN-10: 1590598601 Pro ASP.NET for SQL Server: High Performance Data Access for Web Developers explains how to use ASP.NET 2.0 and SQL Server 2005 most efficiently together. It covers all crucial performance issues and illustrates optimal techniques with enterprise-quality development. Performance is always an issue, and
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
1) General Questions of SQL SERVER
2) Common Questions Asked
Which TCP/IP port does SQL Server run on? How can it be changed?
SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties -> Port number, both on client [...]
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
1) General Questions of SQL SERVER
What is Cursor?
Cursor is a database object used by applications to manipulate data in a set on a row-by-row basis, instead of the typical SQL commands that operate on all the rows in the set at one time.
In [...]
SQL SERVER - 2008 - Interview Questions and Answers Complete List Download
1) General Questions of SQL SERVER
What is RDBMS?
Relational Data Base Management Systems (RDBMS) are database management systems that maintain data records and indices in tables. Relationships may be created and maintained across and among the data and tables. In a relational database, relationships [...]
If Microsoft Office SharePoint Server (MOSS) and your database (MS SQL Server) are running together on same physical server, changing the name of the server (computer) using operating system may create non-functional SharePoint website.
When you change the physical server name the SharePoint is already connected to the SQL instance of old computer name (OldServerName/SQLInstance) and [...]
Primary key, Foreign Key and Default constraint are the 3 main constraints that need to be considered while creating tables or even after that. It seems very easy to apply these constraints but still we have some confusions and problems while implementing it. So I tried to write about these constraints that can be created [...]
I enjoy reading questions from blog readers and answering them. One of the another SQL enthusiastic is Imran who also regulalry answer questions of users on this community blog. Recently he has answered in detail about when to use Unique Index and when to use Unique Constraint.
Cristiano asked following questions :
i need to know how [...]
A Consultoria DSRH está selecionando para uma empresa de grande porte, que já atua no mercado desde 1981, tornando-se líder em seu segmento, está entre as 100 melhores empresas para se trabalhar, eleita pelo Great Place to Work e pela Revista Época, também está entre as 50 melhores empresas de TI & Telecom para se trabalhar no Brasil, eleita, desta vez, pelo Great Place to Work e pela
Imran Mohammed is great SQL Expert and always eager to help community members. He enjoys answering question and solving problems of other community fellows. His answers are always detailed and trustworthy. Today we will see interesting question from Prasant and excellent answer from Imran Mohammed.
Question from Prasant:
Hi,
I want to drop the primary key on one [...]
