sqldbastuff.blogspot.com

SQLDBA

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2. Handy Dyn...

http://sqldbastuff.blogspot.com/

OVERVIEW OF sqldbastuff.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

8

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SQLDBASTUFF.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

June

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.4 out of 5 with 11 reviews

5 star

0

4 star

6

3 star

4

2 star

0

1 star

1

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

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.2 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SQLDBASTUFF.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

8

SSL

EXTERNAL LINKS

0

SITE IP

74.125.225.12

LOAD TIME

0.203 sec

SCORE

6.2

PAGE TITLE

SQLDBA | sqldbastuff.blogspot.com Reviews

<META> DESCRIPTION

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2. Handy Dyn...

<META> KEYWORDS

1 sqldba

2 parentobject varchar 255

3 object varchar 255

4 field varchar 255

5 value varchar 255

6 insert into #temp

7 with tableresults';

8 with checkdb1 as

9 on rn1 =rn2

10 drop table #temp

CONTENT

Page content here

KEYWORDS ON PAGE

sqldba,parentobject varchar 255,object varchar 255,field varchar 255,value varchar 255,insert into #temp,with tableresults';,with checkdb1 as,on rn1 =rn2,drop table #temp,posted by,susheel,no comments,complete server,dbcc freeproccache,from sys stats,done

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

SQLDBA | sqldbastuff.blogspot.com Reviews

https://sqldbastuff.blogspot.com

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2. Handy Dyn...

INTERNAL PAGES

sqldbastuff.blogspot.com

1

SQLDBA: Email Configuration for SSRS:

http://sqldbastuff.blogspot.com/2010/06/email-configuration-for-ssrs.html

Wednesday, June 9, 2010. Email Configuration for SSRS:. Below is the procedure to configure an email account for SSRS. 1 Open reporting service configuration manager and connect to the report server. 2 In the Email setting tab, provide SMTP Server name and an email account that can send emails from the provided SMTP server. Report Server subscriptions might fail to send an email if the remote SMTP server is used with the below error message:. 3 After all it should be something like below . View my comple...

2

SQLDBA: Generic SQL Server Configuration Manager Issues

http://sqldbastuff.blogspot.com/2010/06/generic-sql-server-configuration-errors.html

Tuesday, June 8, 2010. Generic SQL Server Configuration Manager Issues. Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 servers with SQL Server Configuration Manager. Above error will appear while opening SQL server configuration manager, if some of the Managed Object Format (.mof) files are not installed properly and registered during the SQL Server installation. Run the below command in cmd prompt. 1 Stop WMI service.

3

SQLDBA: Installing 32 bit SQL server 2008 on Wow64 (64 bit O.S).

http://sqldbastuff.blogspot.com/2010/06/installing-32-bit-sql-server-2008-on.html

Tuesday, June 22, 2010. Installing 32 bit SQL server 2008 on Wow64 (64 bit O.S). Generally we inclined to navigate X86 folder and use setup100.exe executable file to install the 32 bit SQL server, which leads to below error. In SQL 2008, Installer window is little bit different compare to SQL 2005. Instead of navigating to X86 folder, click on setup.exe and go to Option tab and select the architecture as shown below. Subscribe to: Post Comments (Atom). View my complete profile.

4

SQLDBA: Last execution date/time of DBCC CHECKDB

http://sqldbastuff.blogspot.com/2011/04/last-execution-datetime-of-dbcc-checkdb.html

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2.

5

SQLDBA: DBCC FLUSHPROCINDB(db_id);

http://sqldbastuff.blogspot.com/2010/06/dbcc-flushprocindbdbid.html

Saturday, June 12, 2010. DBCC FLUSHPROCINDB(db id);. Have you guys heard of this? To flush the cached procedure plans of a single DB. DBCC FlushProcINDB(db id);. Subscribe to: Post Comments (Atom). View my complete profile. Awesome Inc. template. Powered by Blogger.

UPGRADE TO PREMIUM TO VIEW 3 MORE

TOTAL PAGES IN THIS WEBSITE

8

OTHER SITES

sqldbaonlinetraining.com

SQL SERVER DBA Online Training. SHAREPOINT SERVER Online Training. SQL SERVER ANALYSIS SERVICES(SSAS) Online Training. SQL SERVER INTEGRATION SERVICES(SSIS) Online Training. SQL SERVER REPORTING SERVICES(SSRS) Online Training. Windows Server Clustering Online Training. Performance Tunning Online Training.

sqldbaonlinetraining.net

oracle functional technical workday online training

More Website Templates @ TemplateMonster.com - September08, 2014! Welcome To Magnific Online Training. Oracle Corporation's application portfolio consisted as. The Oracle E-Business Suite provides a set of financial applications used internationally in businesses. Workday is a web-based ERP software vendor that specializes in human capital management and financial management applications. We have well experienced and real time faculty working at MNC Companies. Magnific Online Training is Leading provider...

sqldbaschool.com

SQL DBA School with Abubeker A Refaw

SQL Server Administration and Management Tools. Different Editions of SQL Server. SQL Server Licensing Models. SQL Server Management Studio (SSMS). SQL Server Profiler continued. SQL Server System and Database Administration. Installing SQL Server 2008. SQL Server Installation Walkthrough-1. SQL Server installation walk-through-2. Upgrading SQL Server SQL Server. Upgrading SQL Server SQL Server-2. The SQL Server 2008 Upgrade Matrix. Client Installation and Configuration. Useful SQL DBA Perfmon Counters.

sqldbashare.blogspot.com

Lets Share Our SQL Knowledge

Lets Share Our SQL Knowledge. I would like to share my knowledge with those who wants to Learn SQL. Monday, February 10, 2014. Powershell script to rename all files in a directory. Path = "c: testdirectory". Filenames = get-childitem -name -filter *.mp4. Foreach ($filename in $filenames). Newfilename = "test video " $increment ".mp4". Write-host $newfilename, "Rename-item " $path$filename. Increment = $increment 1. Wednesday, November 13, 2013. Attach a database in the sql server. Is auto update stats on...

sqldbaskills.blogspot.com

SQL SERVER

Saturday, April 25, 2015. We can delete datafiles with the following commands. Current data will move to other available datafiles. DBCC SHRINKFILE (datafile4, EMPTYFILE);. Remove the data file from the database. REMOVE FILE datafile4;. Friday, November 18, 2011. Log Shipping VS Mirroring. Data Transfer: T-Logs are backed up and transferred to secondary server. Transactional Consistency: All committed and un-committed are transferred. Server Limitation: Can be applied to multiple stand-by servers. The pr...

sqldbastuff.blogspot.com

SQLDBA

Wednesday, April 20, 2011. Last execution date/time of DBCC CHECKDB. Execute the below query to check when was the last time DBCC CHECKDB has ran on all the Databases. CREATE TABLE #temp (. Id INT IDENTITY(1,1),. EXECUTE SP MSFOREACHDB'DBCC DBINFO ( '? SELECT [Value],ROW NUMBER() OVER (ORDER BY ID) AS rn1 FROM #temp WHERE Field IN ('dbi dbname'). CHECKDB2 AS ( SELECT [Value], ROW NUMBER() OVER (ORDER BY ID) AS rn2 FROM #temp WHERE Field IN ('dbi dbccLastKnownGood'). FROM CHECKDB1 JOIN CHECKDB2. Handy Dyn...

sqldbasupport.com

sqldbasupport.com Is For Sale

The domain sqldbasupport.com. Is for sale. To purchase, call BuyDomains.com at 339-222-5115 or 866-846-5160. Click here for more details.

sqldbasupport.wordpress.com

SQL DBA Support . COM - Knowledge Centre for SQL DBAs | By AMIT VAID, MS-SQL Database Administrator

SQL DBA Support . COM – Knowledge Centre for SQL DBAs. 124; Comments RSS. Admn – DBCC Commands. Feature – SQL Server 2005 and 2008. Interview Q and A. Perf – OS Level. Perf – Performance Monitor. Become a member of the SQLDBASupport community and receive notifications of new posts by email. Join 77 other followers. Sql at dbasupport dot in. File Allocation Unit Size – A Myth. Posted on February 28, 2015. The overall meaning of Allocation Unit Size in brief is…. Continue reading →. 124; Leave a comment.

sqldbatrainer.com

SQL DBA Trainer | SQL DBA Training | Oracle DBA training | SQL server dba Training

Are you looking to make a career move that give you stability and great income? Are you looking for a stable IT career? That has a long term outlook, then becoming a SQL DBA may be the right career move for you. SQL DBA as a career! Top 10 reasons report. According to Bureau of Labor Statistics, Database Administrator jobs have a 31% growth. Compared to 14% growth in other categories. The current install base of SQL server. At SQL DBA Trainer. We provide online / in class training.

sqldbatraining.com

SQL DBA Training | MSBI Training | SQL Training

1 (510) 400 - 4845 India:. 91 (040) 64577244, 91 (0)9666440801. SQL School is a Microsoft Partner (ID# 4338151) and ISO 9001:2008 Certified Organization. SQL School Welcomes You! SQL School is an ISO 9001:2008 certified organization offering state-of-art real-time practical trainings on several Microsoft Technologies including SQL Server Development, SQL DBA, MSBI Training (SSIS, SSAS, SSRS), DQS and more courses. All Trainings are Completely Practical and Real-time. Register Today for a Free Demo.

sqldbatrainingchennai.com

Welcome sqldbatrainingchennai.com