Tuesday, July 5, 2022

Difference between "Maven Install" and "Maven Build"

›
  First of all,   build   is   not a phase   in the standard Maven lifecycles, whereas   install   is one.   mvn install   will invoke all t...
Monday, November 19, 2018

MSSQL - Database CPU Usage

›
Scripts to generate the CPU usage of a database. DECLARE @ts_now bigint = (SELECT cpu_ticks/(cpu_ticks/ms_ticks)FROM sys.dm_o...

MSSQL - Get size of all tables in database

›
below scripts use to generate the all the Database table size and number of rows of records in the table. use distribution SELECT    ...
Saturday, December 2, 2017

How tempDB works in MSSQL

›
Temp table is stored in tempdb until the connection is dropped (or in the case of a global temp tables when the last connection using it is...
Tuesday, June 30, 2015

Query to get the names of all tables in SQL

›
SQL Server  USE your_database SELECT name FROM sys.tables SQL Server -  get the fields info SELECT TABLE_SCHEMA, TABLE_NAME,         C...
Wednesday, December 26, 2012

Check DB Table Size (sp_spaceused)

›
sp_spaceused Displays the number of rows, disk space reserved, and disk space used by a table, indexed view, or Service Broker queue in the...
Monday, November 19, 2012

Limit - MySQL Command

›
Limit  is used to limit your MySQL query results to those that fall within a specified range. It is use for select number of row of record f...
Monday, June 11, 2012

The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator

›
SQL Server Error Message : The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator. ...
Monday, May 21, 2012

Saving changes is not permitted in SQL 2008 Management Studio

›
When you design a table in a database and then try to make a change to a table structure that requires the table to be recreated, the Dat...
Friday, May 18, 2012

SharePoint webparts AJAX enabled?

›
The web parts in SharePoint 2007 are NOT Ajax enabled.  AJAX support didn't come along for 2007 until SP1.  The web parts weren't re...
Sunday, May 6, 2012

Add Linked server using Command

›
A linked server configuration allows Microsoft® SQL Server™ to execute commands against OLE DB data sources on different servers. Linked se...
Friday, February 17, 2012

Sharepoint - SPSecurityTokenServiceConfig is not recognized

›
i try to run SET- SPSecurityTokenServiceConfig command in powershell, but it return me error message "   SET- SPSecurityTokenServiceC...
Wednesday, February 15, 2012

Microsoft.Ace.OLEDB.12.0 and OPENROWSET Errors

›
If you imports excel file into database using sql query  INSERT INTO newtable select  * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0...
Monday, January 30, 2012

The OLE DB provider "Microsoft.ACE.OLEDB.12.0" has not been registered

›
If you run below SQL statement --------------------------------------------------------- Select * into DBTable FROM OPENROWSET('Micro...
Wednesday, January 11, 2012

DTS not support in SQL Server 2008 R2

›
Limited SQL Server 2000 DTS Functionality on 64-bit Operating Systems SQL Server 2008 does not include support for DTS in the following ci...
Friday, December 23, 2011

Import Excel Data into Mssql using SQL Statement

›
you need to run one line per line, if you run all SQL together. you will get below error message: Incorrect syntax near 'sp_configure...
Friday, September 30, 2011

Database owner is already a user in the database

›
Error : Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46 The proposed new database owner is already a user in the database...

Back Up the Transaction Log When the Database Is Damaged

›
To create a backup of the currently active transaction log Execute the BACKUP LOG statement to back up the currently active transaction log,...
Thursday, September 29, 2011

10 reasons why go for SQL Server 2008

›
10.   Plug-in model for SSMS .   SSMS 2005 also had a plug-in model, but it was not published, so the few developers that braved that envir...