Browse by Tags

Sometimes we see in MSDN forums and in real process problems about string columns. In this theme, we will use Datalength() function. Datalength() function returns the length of the data in the column in contrast to the length of the column. This function we can use in strings and another (BLOB...

One of the unusual string functions in SQL Server is formatmessage(). What is formatmessage() function? Where may we need to use this unusual function? Using FORMATMESSAGE(), you can format strings using a printf()-like syntax. It takes a parameter specifying the ID of the message from the...

First, we will create #test table with a unique index and insert duplicate rows. CREATE TABLE #test ( name varchar (15) UNIQUE , -- Define a UNIQUE constraint profession varchar (25), salary int DEFAULT 0, ) INSERT #test VALUES ( 'Paul Raj' , 'Actor'...

Table of Contents Introduction Problem Solution Conclusion See Also Introduction This article is about how to automatically stop unnecessary data when inserting data in a SQL Server Table. Problem One of the problematic aspects of SQL Server is to stop the unnecessary data at the time...

Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions. In this wiki, you will find articles related to SQL Server 2012 by Features, Server Component or Management tools. You can find the full SQL Server Help documentation...

Recently, in one of our applications, while trying to configure reporting services configuration we were getting the below error while trying to connect to a SQL database. Checked the remote server connections for the database and it was enabled. Went into the component services...

Bazen şirketinizdeki elektrik kesintisi sonucu olmadık bir şekilde aksilikler üst üste gelmiş olabilir. Dosyalar bozulmuş, database deki MDF ve LDF dosyaları bir biriyle uyumsuz olduğuna dair hatalar veriyor ve ya MASTER db in bozulduğuna dair uyarılar alıyor olabilirsiniz. Database...

SQL Serveriniz üzerindeki veri tabanlarını bir kaç yöntemle kolayca yedekleyebilirsiniz. Örneğin task oluşturarak, SQL Agent aracılığı ile belli zaman aralıklarında yedekleme yapabilir, ya da veri tabanını bir yerden bir yere taşımak isterseniz attach, detach işlemi yapabilirsiniz bunun dışında script...

Merhaba; bugün yeni bir yazı serisi ile karşınızdayım J Bu yazı serimde neler var peki? SQL Server da tablo oluşturmak, yedeklemek, geri yüklemek, SQL Server Agent ile otomatik yedeklemek, Kısaca bazı T-SQL komutları gibi bilgilere yer vermeye çalışacağım. SQL Server dediğimizde ne anlıyoruz? Neden...

Table of Contents Pr-requisites: Linux System Status Linux System Network Status SA Password for SQL Remote Access Accessing SQL Server from SSMS Traditionally, Microsoft SQL Server, being part of Microsoft’s back office platform, has always run on Windows operating systems. However, Microsoft has...

Table of Contents Scope Inconsistency in Resource DB Online Content In SQL Server 2005 In SQL Server 2008 and Onwards Moving the Location Conclusion See Also Caution Microsoft strongly suggests you NOT CHANGE location of resource database data and log files. This article...

Cliquez ici pour changer la langue . Table of Contents Contenu 1.0 Nouveautés du Service Pack 2 2.0 Avant l'installation de Service Pack 2 2.3. Toutes les fonctionnalités d'une instance de SQL Server doivent avoir un niveau de version identique avant qu'une mise à jour cumulative soit...

NOTE : This page was translated from this Spanish version by St. Joseph Lopez . This article is available in other languages: Spanish More and more customers are getting to know about PowerPivot and seek more guidance on when to use it with SQL Server...

Table of Contents Introduction Problem Definition Solution Conclusion See Also Introduction String splitting is one of the most common problems in the Transact-SQL and programming in general. There are many blog posts discussing splitting a comma-delimited string in SQL. My favorites could ...

This article provides a way to generate DROP and ADD CONSTRAINT queries for all tables of the database. Table of Contents Introduction Foreign keys Drop Foreign Key Add Foreign key Primary Keys Drop Primary key Add Primary key Default Constraints Drop Default Constraint Add Default Constraint Conclusion...

Table of Contents Environment for tests Setting the recovery mode of the database to BULK_LOGGED before usage of DELETE Use of TRUNCATE instead of DELETE for the deletion of records Conclusion See Also How often do you have a situation when you need to remove old records from a table to free storage...

Table of Contents Introduction Solutions 1. Using NEWID as base string & NEWID to generate a random length Basic Idea Code Advantages & Disadvantages 2. Using Clean NEWID as base string & NEWID to generate a random length. Basic Idea Code Advantages & Disadvantages 3. Performing data...

Duplicates of data in an Excel file you receive is an everyday problem. It is okay if we have 10 records of data in a file we receive and only 2 of them are duplicates. It will be a small manual work to remove those two duplicate records in the file and then ETL (Extract, Transform, and Load) the data...

Table of Contents Introduction Minimal Logging Under Bulk-Logged Recovery Model Logging under Full-Recovery Model: Minimal Logging in Bulk-Logged Recovery Model: Full vs Bulk-Logged: Testing For Minimal Logging Under Bulk-Logged Recovery Model: First Requirement: Second Requirement: Is TRUNCATE minimally...

use tempdb go create table #stores (store_id int , store_name nvarchar(20)) create table #reports (report_id int , store_id int , [daily sales] int , [daily visits] int , [daily quessions] int ) insert into #stores(store_id,store_name...

Table of Contents Introduction Building the Environment for Testing Moving Old Data Freezing Table Conclusion References See Also Other Languages Introduction This article provides a way to maintain one or more tables in a database without the possibility of change to the structure or your data...

Table of Contents Introduction Building the Environment for Testing Environment Requirements Automation in Excel using VBA Conclusion References See Also Other Languages Introduction Critical situations, especially for small business with hardware and/or software limited. Also on places with...

Nowadays the buzz word is Data Analytics. Customers are savvy and want to know how we can help analyze their data. Data Analytics should be part of every medium to large Dynamics 365 project. This is the first of many blogs on Data Analytics. Good news is that Microsoft is already leading...

Table of Contents Introduction Count the number of rows in each Table Using T-SQL Using the Object Explorer Details panel Conclusion References See Also Other Languages Introduction A good SQL Server administration requires verification and routine monitoring for growth size of each database...

Table of Contents Introduction Scenario Cause Solution Set the Maximum Request Length in Report Server Web Config Set the Maximum Request Length in Report Manager Web Config Uploading large report in SQL Server Reporting Service. Applies To Conclusion Reference Introduction In this article, we...