Next2nd blog

noreply@blogger.com (suresh) — Wed, 25 Jan 2023 22:55:00 +0530

Understanding the SQL ROW_NUMBER() FunctionThe ROW_NUMBER() function in SQL Server is a powerful tool that assigns a sequential integer to each row within a partition of a result set. The numbering resets for each partition as specified by the ORDER BY clause. This function is essential for tasks such as pagination, ranking, and complex data analysis

INSERT Statement

noreply@blogger.com (suresh) — Wed, 13 Jan 2021 22:50:00 +0530

SQL Server INSERT statementTo insert single or multiple records into a table, use the SQL Server (Transact-SQL) INSERT statement. There are several methods for managing data to insert into SQL Server. In this article, we will look at how to create and insert data into both permanent and temporary tables. The following is an example of the most basic INSERT statement: &

Create a Table

noreply@blogger.com (suresh) — Tue, 12 Jan 2021 10:54:00 +0530

Create a Table in SQL Server Management Studio Step 1: Create a database If you haven’t already done so, create a database in SQL Server Management Studio. For illustration purposes, a database called Sales was created: Note: To avoid any permission issues, you may want to run SQL Server Management Studio as an administrator. Step 2: Create a

Create a Database

noreply@blogger.com (suresh) — Mon, 11 Jan 2021 21:36:00 +0530

Create a database in SQL Server by using SQL Server Management Studio or Transact-SQL Method 1 – To create a database, using: Using SQL Server Management Studio In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance.Right-click Databases, and then click New Database. 3. In New Database, enter a database name. &

How to Enable Multiple RDP Sessions in Windows 2016

noreply@blogger.com (suresh) — Thu, 30 Aug 2018 09:32:00 +0530

How to Enable Multiple RDP Sessions in Windows Server 2016 By default, Windows Server 2016 servers allow a single Remote Desktop session. If only one session is available you may choose to enable multiple RDP sessions. This article describes the process for enabling multiple sessions. Enable Multiple RDP Sessions 1. Log into the

How to move TempDB from one drive to another drive (New Drive)

noreply@blogger.com (suresh) — Thu, 20 Jul 2017 11:01:00 +0530

Get Logical File Name and location of TempDB USE TempDB GO EXEC sp_helpfile GO Or SELECT name ,physical_name AS Location FROM sys.master_files WHERE database_id = DB_ID(N'tempdb') GO Change the location of TempDB USE master GO ALTER DATABASE TempDB MODIFY FILE (NAME = tempdev, FILENAME = 'd:\datatempdb.mdf') GO ALTER DATABASE TempDB MODIFY FILE (NAME = templog,

Taking backup of all the databases in SQL Server

noreply@blogger.com (suresh) — Mon, 21 Mar 2016 15:15:00 +0530

Using below script you can back up all databases on your SQL Server. Using this you can backup databases in the multiple disk drives in a compress mode. If you need please change the script according to your requirement. First create a Backup folder on disk drives. DECLARE @FileName01 AS VARCHAR(200) -- Filename for backup 1 DECLARE @FileName02 AS VARCHAR(200) -- Filename for backup 2

Queries currently run on SQL Server

noreply@blogger.com (suresh) — Fri, 26 Feb 2016 15:12:00 +0530

Using below Dynamic Management View (DMV) query, you can view the queries which are currently running. SELECT * FROM sys.dm_exec_requests Each row represents a currently running query. Using below query, you can view most required details of the currently running queries. Output columns of the query: Blocking Session ID, login Name, Data Base Name, Status, Query

Business Problems for Data Mining

noreply@blogger.com (suresh) — Fri, 30 Mar 2007 16:31:00 +0530

Data mining techniques can be applied to many applications, answering various types of businesses questions. The following list illustrates a few typical problems that can be solved using data mining:Churn analysis: Which customers are most likely to switch to a competitor? The telecom, banking, and insurance industries are facing severe competition these days. On average, each new mobile phone

Google Analytics open for all!

noreply@blogger.com (suresh) — Fri, 24 Nov 2006 22:43:00 +0530

Google has finally announced that you no longer need an invitation to use their brilliant free web stats program Google AnalyticsIf you have a website or blog I strongly suggest that you sign up to this service right now!More Info

How to make Adobe Reader 7.0 load faster

noreply@blogger.com (suresh) — Mon, 6 Nov 2006 12:07:00 +0530

Whenever I install Adobe’s Acrobat Reader I also uninstall most of the pointless plugins, to speed up its dog-slow startup process. So here’s what I just did on my machine: In Edit-Preferences, do the following: General tab: turn off “Automatically save document changes” Internet tab: turn off all three checkboxes Page Display tab: turn on “CoolType” Search tab: turn off “Enable fast find”

Use Substitution Control for Dynamic sections of a Cached Page

noreply@blogger.com (suresh) — Fri, 3 Nov 2006 11:18:00 +0530

Ways of Caching an ASP.NET Page in which we are limited to two optionsi. Caching the whole page using Output Caching - Not applicable in many realtime scenarios where some sections of the page need to be dynamic ex.- Stock Ratesii. Caching Usercontrols by Fragment Caching - Difficult to implement since page requires to be breaked into separate usercontrols for enabling/disabling caching.So, if we

Save Windows Update Downloads

noreply@blogger.com (suresh) — Sat, 28 Oct 2006 21:21:00 +0530

If you use the regular Windows Update Web site, updates you select are downloaded and installed, you are not offered the option to save them for later use, or for distribution to non-Internet connected PC's. Nor can you download updates for other computers (hardware/software drivers for example). Also, a System Restore could overwrite updated files, but Windows Update would still show the update

SQL Server 2005 Installation

noreply@blogger.com (suresh) — Sat, 28 Oct 2006 21:02:00 +0530

Installing SQL Server 2005We used the CDs from the 2 CD set for SQL server 2005 enterprise. Insert the first CD, it autostarts. In the 'Install' section, click 'Server components tools etc.'. This launches the setup.exe program. Accept the license agreement. Click Next. At the next window (Installing Prerequisites), the installer says that it needs to install .Net 2.0, MS SQL Native Client and

Google Co-op Custom Search Engine

noreply@blogger.com (suresh) — Fri, 27 Oct 2006 23:18:00 +0530

Google Co-op added a new service to create your own search engine. Google Co-op custom search engine allows you to place a search box and search results on your website using your own design(similar to AdSense search on your site). You can specify or prioritize the websites you want to include in searches. Also, you can invite your friends to contribute and build a search engine for your

Windows XP Shortcuts II

noreply@blogger.com (suresh) — Mon, 16 Oct 2006 09:56:00 +0530

Code & Description Shown below:Run Commands to access the control panel: Code:Add/Remove Programs control - appwiz.cplDate/Time Properties control - timedate.cplDisplay Properties control - desk.cplFindFast control - findfast.cplFonts Folder control - fontsInternet Properties

Windows XP Shortcuts I

noreply@blogger.com (suresh) — Mon, 16 Oct 2006 09:20:00 +0530

Code & Description Shown below:Run Commands: Code:compmgmt.msc - Computer managementdevmgmt.msc - Device managerdiskmgmt.msc - Disk managementdfrg.msc - Disk defrageventvwr.msc - Event viewerfsmgmt.msc - Shared foldersgpedit.msc - Group policieslusrmgr.msc - Local users and groupsperfmon.msc -

Tips

noreply@blogger.com (suresh) — Mon, 16 Oct 2006 09:07:00 +0530

12 Tips for Delivering a Knockout Business Presentation From Wendy Russell (about.com) 1. Know your material: Knowing your material thoroughly will help you decide what information is essential to your presentation and what can be left out. It will help your presentation to flow naturally, allowing you to adjust to unexpected questions or events, and it will help you feel more

Tips & Tricks

noreply@blogger.com (suresh) — Thu, 12 Oct 2006 22:21:00 +0530

Extend or Reset Trial Period of Trial Demo SoftwareA lot of software and applications are released as a shareware, also known as demoware (demo) or trialware (trial version), where users can download the trial version shareware from the Internet or get the apps from distributed magazine cover-disks, and use it for a stipulated period of time (trial period), free or charge without any payment. The