saveadba.blogspot.com

SQL Server

Friday, June 26, 2015. Sybase 15.7: Add new device and extend the database. As mentioned in my previous post I have been working on Sybase databases too. Firstly, let me tell you how similar they are and it's relatively easy transition for someone who knows SQL Server and can work around in a UNIX environment. One of my first problems that I had to resolve was to increase the size of a database that was getting full. 1) First add a new device. PHYSNAME='/home/dump/sybase dump/sybdata/GLUT UDL04.dat',.

http://saveadba.blogspot.com/

OVERVIEW OF saveadba.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SAVEADBA.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

October

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Wednesday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.1 out of 5 with 14 reviews

5 star

9

4 star

2

3 star

1

2 star

0

1 star

2

Hey there! Start your review of saveadba.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.1 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SAVEADBA.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

20

SITE IP

173.194.46.107

LOAD TIME

0.094 sec

SCORE

6.2

PAGE TITLE

SQL Server | saveadba.blogspot.com Reviews

<META> DESCRIPTION

Friday, June 26, 2015. Sybase 15.7: Add new device and extend the database. As mentioned in my previous post I have been working on Sybase databases too. Firstly, let me tell you how similar they are and it's relatively easy transition for someone who knows SQL Server and can work around in a UNIX environment. One of my first problems that I had to resolve was to increase the size of a database that was getting full. 1) First add a new device. PHYSNAME='/home/dump/sybase dump/sybdata/GLUT UDL04.dat',.

<META> KEYWORDS

1 sql server

2 use master

3 disk init

4 name='glut udl04

5 vstart=0

6 cntrltype=0

7 dsync=false

8 alter database sybpr

9 with override

10 posted by

CONTENT

Page content here

KEYWORDS ON PAGE

sql server,use master,disk init,name='glut udl04,vstart=0,cntrltype=0,dsync=false,alter database sybpr,with override,posted by,kaykay,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels configuration manager,window

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQL Server | saveadba.blogspot.com Reviews

https://saveadba.blogspot.com

Friday, June 26, 2015. Sybase 15.7: Add new device and extend the database. As mentioned in my previous post I have been working on Sybase databases too. Firstly, let me tell you how similar they are and it's relatively easy transition for someone who knows SQL Server and can work around in a UNIX environment. One of my first problems that I had to resolve was to increase the size of a database that was getting full. 1) First add a new device. PHYSNAME='/home/dump/sybase dump/sybdata/GLUT UDL04.dat',.

INTERNAL PAGES

saveadba.blogspot.com

1

SQL Server: May 2015

http://saveadba.blogspot.com/2015_05_01_archive.html

Friday, May 22, 2015. SQL Server 2005/2008/R2/2012: Cannot connect to WMI provider. You do not have permission or the server is unreachable. Invalid class[0x80041010]. 8220;Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with the SQL Server Configuration Manger. Saw this message when I tried to open SQL Server Configuration manager. With a quick search on Google led me to this website. On one of my se...

2

SQL Server: Non-SysAdmins have been denied permission

http://saveadba.blogspot.com/2013/03/non-sysadmins-have-been-denied.html

Thursday, March 28, 2013. Non-SysAdmins have been denied permission. Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed. Yesterday, I scheduled some maintenance plans for one of my new servers and today I see that all of them failed with the same error like the one mentioned above. There are various work arounds for this error but the simplest according to me would be to change the ownership of the job to the SA account.

3

SQL Server: Error: 18486, Severity: 14, State: 1

http://saveadba.blogspot.com/2013/03/error-18486-severity-14-state-1.html

Tuesday, March 12, 2013. Error: 18486, Severity: 14, State: 1. How to find locked out user and unlock them? Login failed for user 'xxx' because the account is currently locked out. The system administrator can unlock it. [CLIENT: local machine ]. Error: 18486, Severity: 14, State: 1. Today I had a client who asked me how to unlock a SQL Server Login. So firstly I listed out all the logins that were locked out using the following query. Reset password for the login while unlocking'. Error: 18486, Severity...

4

SQL Server: SQL Server 2008/2012: Automate restore all transaction log backup files

http://saveadba.blogspot.com/2015/05/sql-server-20082012-automate-restore.html

Friday, May 8, 2015. SQL Server 2008/2012: Automate restore all transaction log backup files. It's been a long time since I posted something on this blog. Had been working a lot on the IBM DB2 databases for the last couple of years. So it was business as usual in SQL Server. Hence, nothing noteworthy in SQL Server to blog about. But here's one script that saved me several hours yesterday. So wrote this script to create commands to RESTORE log backup files which can be then run in a query window. 5) Copy ...

5

SQL Server

http://saveadba.blogspot.com/2015/06/oracle-11g-version-1.html

Friday, June 26, 2015. Oracle 11g" Java version 1.5.0 17 not supported sql developer. Enter the full pathname for java.exe. I started working for a new company and here I am on a team which supports Oracle and Sybase database along with SQL Server databases. So going forward you might see some blog posts from those database platforms as well. Java version 1.5.0 17 not supported sql developer. C: Oracle product 11.2.0 client 1 jdk. C: Program Files Java jdk1.8.0 45. Subscribe to: Post Comments (Atom).

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

wisdom-soup.com

Troubleshooting | Wisdom-Soup

http://www.wisdom-soup.com/blog/category/troubleshooting

Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...

wisdom-soup.com

SQL Server Security | Wisdom-Soup

http://www.wisdom-soup.com/blog/category/sql-server-security

Share SQL Server Tips and Tricks and Related News. Category Archives: SQL Server Security. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. To obtain the mirroring endpoint name.

wisdom-soup.com

Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission | Wisdom-Soup

http://www.wisdom-soup.com/blog/troubleshooting/unable-drop-windows-login-sql-server-due-endpoint-permission

Share SQL Server Tips and Tricks and Related News. Unable to Drop Windows Login from SQL Server due to ENDPOINT Permission. While we tried to drop one of our Windows Login from SQL Server, part of our house-keeping task, and SQL Server prevent us from dropping the Windows Login even though we have unmapped all the database mapped and owned by the login. It works fine for us before this. Msg 15173, Level 16, State 1, Line 2. But our SQL Server was not configured with mirroring. This entry was posted in SQ...

wisdom-soup.com

SQL Server Build Version

http://www.wisdom-soup.com/blog/sql-server-version

Share SQL Server Tips and Tricks and Related News. This list is original from SQLTeam.com website. And MS SQL Server Builds. Last updated on 24 July, 2013). You can also find the SQL Server and Updates Builds Numbers. From Microsoft TechNet website. Please visit to this page. On how to determine the version and edition of SQL Server and its components. SQL Server 2012 CU1. SQL Server 2012 RTM. SQL Server 2008 R2. SQL Server 2008 R2 SP1 CU6. SQL Server 2008 R2 SP1 CU5. SQL Server 2008 R2 SP1 CU4. SQL Serv...

wisdom-soup.com

Tempdb | Wisdom-Soup

http://www.wisdom-soup.com/blog/tag/tempdb

Share SQL Server Tips and Tricks and Related News. Script to Check TempDB Speed. The following script adopted from Brent Ozar’s blog on his TempDB Performance and Configuration. Topic I strongly encourage you to pay a visit to his site. This query hits the dynamic management function (DMF) sys.dm io virtual file stats for all of the TempDB data files and lists out how fast they’re responding to write (and read) requests:. Are writes being evenly distributed between data files? February 28, 2014. ALTER DA...

wisdom-soup.com

Dmv | Wisdom-Soup

http://www.wisdom-soup.com/blog/tag/dmv

Share SQL Server Tips and Tricks and Related News. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. Detect SQL Server CPU Pressure. And tagged cpu pressure.

wisdom-soup.com

sp_MSForEachDB | Wisdom-Soup

http://www.wisdom-soup.com/blog/tag/sp_msforeachdb

Share SQL Server Tips and Tricks and Related News. Tag Archives: sp MSForEachDB. How to: Find a Table on a SQL Server across all Databases. Some times it is difficult to find a table name from a SQL instance that hosted tremendous database. “Which database I suppose to search for? 8221; is the question that often pop-up in DBA’s mind and they hope the user can give them the database name as well. Sadly speaking in most cases user do not know which database their application connect to. AS DB, * FROM [?

wisdom-soup.com

T-SQL | Wisdom-Soup

http://www.wisdom-soup.com/blog/category/t-sql

Share SQL Server Tips and Tricks and Related News. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. Detect SQL Server CPU Pressure. And tagged cpu pressure.

wisdom-soup.com

Cpu Pressure | Wisdom-Soup

http://www.wisdom-soup.com/blog/tag/cpu-pressure

Share SQL Server Tips and Tricks and Related News. Tag Archives: cpu pressure. How to: Verifying CPU Pressure via Signal Wait Time. Use the following query to verify the CPU pressure via signal wait time through MS SQL Server Management Studio. USE master GO SELECT SUM(signal wait time ms) AS TotalSignalWaitTime , ( SUM(CAST(signal wait time ms AS NUMERIC(20, 2) ) / SUM(CAST(wait time ms AS NUMERIC(20, 2) ) * 100 ) AS PercentageSignalWaitsOfTotalTime FROM sys.dm os wait stats. And tagged cpu pressure.

UPGRADE TO PREMIUM TO VIEW 11 MORE

TOTAL LINKS TO THIS WEBSITE

20