skip to main
|
skip to sidebar
Manjunath C Bhat's Blog
Pages
Home
About
About
About Me
No comments:
Post a Comment
Home
Subscribe to:
Posts (Atom)
MSSQL 2000 Certified
MSSQL 2005 Certified
MSSQL 2008 Certified
Fan Page
Catch Me on FaceBook
Manjunath C Bhat
Create Your Badge
Manjunath C Bhat
Dharwad,Bangalore, Karnataka, India
View my complete profile
Subscribe via email
Enter your email address:
Delivered by
FeedBurner
Other Public Profiles Do visit once
Manjunath C Bhat
Create Your Badge
Blog Archive
2014
(1)
January
(1)
General Approach To SQL Server Performance Tuning
2013
(18)
December
(1)
November
(12)
October
(5)
2012
(1)
January
(1)
2011
(17)
November
(2)
October
(1)
August
(2)
April
(4)
March
(7)
February
(1)
2010
(21)
November
(4)
October
(3)
September
(1)
July
(6)
June
(2)
May
(3)
March
(2)
Subscribe To
Posts
Atom
Posts
All Comments
Atom
All Comments
Follow Me At
Face Book
LinkedIn
MySpace
Orkut
Twitter
Followers
Popular Posts
ReportServer: Deleting Encryption Key in SQL Server Reporting Services Configuration Manager
Below are the steps to Delete the Encryption Key in SQL Server Reporting Services Configuration. Before Deleting make sure you have taken ...
Backup Database Error SQL Server 2012: This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally
Microsoft SQL Server 2012 has introduced a new feature called AlwaysOn High Availability. There are numerous resources online to get informa...
The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library.[]
There can be many reasons for a Login Failure to SQL Server Instance. Out of this you may get one as “The login packet used to open the co...
ReportServerError: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.
There will be often Business Needs to Have your Report Server Migrated Moved or Restored onto Different Environment. You May come up with D...
SSAS Deployment Failed - Error 3 The project could not be deployed to the '' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
In one of my Old Post, I posted a SSAS Deployment failed because of insufficient rights for a User to deploy the cube/project to SSAS Server...
Logon failure: unknown user name or bad password
This is one of the very often faced error for job failure. Exact error goes as follows: Unable to start execution of step (reason: Error ...
SELECT @@SERVERNAME Showing Null
SELECT @@SERVERNAME With multiple instances of SQL Server installed, @@SERVERNAME returns the following local server name information if th...
SQL Server Agent Proxies
SQL Server Agent Proxies are very helpful in executing some jobs. I had came across a situation where in I was scratching my head so as to h...
T-SQL to get Database backup details
Below is a simple yet powerful query to get the details about your database backup. This query can be customised as per your needs as this i...
Cannot use the PAGE granularity hint on the table
This seems to be an very interesting error which one may receive while running DBCC ShrinkDatabase command. The full error is as follows ...
Categories
#SQLServer
#TSQL
2000-2012
active process
AlwaysOn High Availability
Associate Schema
backup
backup all databases
BRH
change collation
Change Data Capture
child table
collation
columns
completion time
Create Role
Create Schema
Credentials
Crystal Reports
CTE
Database
database backup
Database Mail
DBCC
DBCC ShrinkFile
DBCC UPDATEUSAGE
default email
default trace
Details
dmv
Edition Upgrade
Error Codes
Errors
expensive
expensive queries
extendedcatalog
failure
File ID
Fixed Drives Free Space in Percentage
full backup
group
grouping
In-row data
last activity
login creator
login information
logon
logon failure
mail box
MySQL
New Role
New Schema
Nth level
Null
parent table
performance tuning
primary column details
primary key details
primay
proxy
ReportingServices
Reports
ReportServer
ReportServerTempDB
Role
running process details
running processes
Schema
ServerName
Shrinkfile
sql
SQL 2000 Database
SQL Server
SQL Server Agent
sql server collation
SQL Server Edition Upgrade
SQL Server performance
SQL server performance tuning
SQL Server Start time
sql server tuning
SQL Server Upgrade
SQL Server Uptime
SSAS
SSAS Access
SSAS Deployment
SSAS Port Opening
Starttime
stored procedure to get most expensive queries
Stored Procedure Users Server Roles connected
sysprocesses
T-SQL
TCP/IP Port Opening
TempDB
TSQL
type In-row data
unused index on database
Upgrade
Uptime
Windows SQL Server
XML PATH
Popular Posts
ReportServer: Deleting Encryption Key in SQL Server Reporting Services Configuration Manager
Below are the steps to Delete the Encryption Key in SQL Server Reporting Services Configuration. Before Deleting make sure you have taken ...
Backup Database Error SQL Server 2012: This BACKUP or RESTORE command is not supported on a database mirror or secondary replica. BACKUP DATABASE is terminating abnormally
Microsoft SQL Server 2012 has introduced a new feature called AlwaysOn High Availability. There are numerous resources online to get informa...
The login packet used to open the connection is structurally invalid; the connection has been closed. Please contact the vendor of the client library.[]
There can be many reasons for a Login Failure to SQL Server Instance. Out of this you may get one as “The login packet used to open the co...
ReportServerError: An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Invalid object name ''. Could not use view or function 'ExtendedCatalog' because of binding errors.
There will be often Business Needs to Have your Report Server Migrated Moved or Restored onto Different Environment. You May come up with D...
SSAS Deployment Failed - Error 3 The project could not be deployed to the '' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server. 0 0
In one of my Old Post, I posted a SSAS Deployment failed because of insufficient rights for a User to deploy the cube/project to SSAS Server...
Logon failure: unknown user name or bad password
This is one of the very often faced error for job failure. Exact error goes as follows: Unable to start execution of step (reason: Error ...
SELECT @@SERVERNAME Showing Null
SELECT @@SERVERNAME With multiple instances of SQL Server installed, @@SERVERNAME returns the following local server name information if th...
SQL Server Agent Proxies
SQL Server Agent Proxies are very helpful in executing some jobs. I had came across a situation where in I was scratching my head so as to h...
T-SQL to get Database backup details
Below is a simple yet powerful query to get the details about your database backup. This query can be customised as per your needs as this i...
Cannot use the PAGE granularity hint on the table
This seems to be an very interesting error which one may receive while running DBCC ShrinkDatabase command. The full error is as follows ...
Blog Archive
▼
2014
( 1 )
▼
January
( 1 )
General Approach To SQL Server Performance Tuning
►
2013
( 18 )
►
December
( 1 )
►
November
( 12 )
►
October
( 5 )
►
2012
( 1 )
►
January
( 1 )
►
2011
( 17 )
►
November
( 2 )
►
October
( 1 )
►
August
( 2 )
►
April
( 4 )
►
March
( 7 )
►
February
( 1 )
►
2010
( 21 )
►
November
( 4 )
►
October
( 3 )
►
September
( 1 )
►
July
( 6 )
►
June
( 2 )
►
May
( 3 )
►
March
( 2 )
No comments:
Post a Comment