Pinal Dave at SQL Authority is a SQL Server Performance Tuning Expert and an independent consultant. I will fix your SQL Server Performance problems.
http://blog.sqlauthority.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Wednesday
LOAD TIME
6.5 seconds
16x16
32x32
64x64
128x128
160x160
192x192
PAGES IN
THIS WEBSITE
59
SSL
EXTERNAL LINKS
3,346
SITE IP
96.127.165.210
LOAD TIME
6.49 sec
SCORE
6.2
SQL Authority with Pinal Dave - SQL Server Performance Tuning Expert | blog.sqlauthority.com Reviews
https://blog.sqlauthority.com
Pinal Dave at SQL Authority is a SQL Server Performance Tuning Expert and an independent consultant. I will fix your SQL Server Performance problems.
blog.sqlauthority.com
SQL SERVER - FIX : ERROR : (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: ) - Journey to SQL Authority with Pinal Dave
https://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error
Fix Your SQL Server. Weekly Questions and Answers. SQL in Sixty Seconds. SQL SERVER – FIX : ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: ). May 21, 2009. SQL Tips and Tricks. Regular readers of my blog are aware of the fact that I have written about this subject umpteen times earlier, and every time I have spoken about a new issue related to it. Few days. Ago, I had redone my local home network. I have LAN setup. Named Pipes...
SQL SERVER - ERROR: FIX - Database diagram support objects cannot be installed - Journey to SQL Authority with Pinal Dave
https://blog.sqlauthority.com/2012/02/06/sql-server-error-fix-database-diagram-support-objects-cannot-be-installed-because-this-database-does-not-have-a-valid-owner
Fix Your SQL Server. Weekly Questions and Answers. SQL in Sixty Seconds. SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed. February 6, 2012. I was able to install the database successfully. He informed me that he has created a database diagram so I can easily understand his database tables. As soon as I tried to open the database diagram I faced following error. For a while I could not figure out how to resolve the error. Workaround / Fix / Solution :. Well, for a while I at...
SQL SERVER - Remove Duplicate Entry from Comma Delimited String - UDF - Journey to SQL Authority with Pinal Dave
https://blog.sqlauthority.com/2009/01/15/sql-server-remove-duplicate-entry-from-comma-delimited-string-udf
Fix Your SQL Server. Weekly Questions and Answers. SQL in Sixty Seconds. SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF. January 15, 2009. SQL Tips and Tricks. I love reader’s contribution this blog as that brings variety in articles. I encourage my readers to provide their contribution and I will publish then with their name. Blog Reader Ashish Jain. 342,34,456,34,3454,456,aa,bb,cc,aa'. Reference : Pinal Dave ( http:/ blog.SQLAuthority.com. February 7, 2011. July 19, 2010. SELECT ...
SQL SERVER - Microsoft SQL Server 2014 CTP1 Product Guide - Journey to SQL Authority with Pinal Dave
https://blog.sqlauthority.com/2013/06/16/sql-server-microsoft-sql-server-2014-ctp1-product-guide
Fix Your SQL Server. Weekly Questions and Answers. SQL in Sixty Seconds. SQL SERVER – Microsoft SQL Server 2014 CTP1 Product Guide. June 16, 2013. SQL Tips and Tricks. This SQL Server 2014 CTP1 Product Guide contains few interesting White Papers, a Datasheet and Presentation Deck. Here is the list of the white papers:. Mission-Critical Performance and Scale with SQL Server and Windows Server. Faster Insights from Any Data. Platform for Hybrid Cloud. SQL Server In-Memory OLTP Internals Overview for CTP1.
SQL SERVER - Query to Find First and Last Day of Current Month - Date Function - Journey to SQL Authority with Pinal Dave
https://blog.sqlauthority.com/2007/05/13/sql-server-query-to-find-first-and-last-day-of-current-month
Fix Your SQL Server. Weekly Questions and Answers. SQL in Sixty Seconds. SQL SERVER – Query to Find First and Last Day of Current Month – Date Function. May 13, 2007. SQL Tips and Tricks. Following query will run respective to today’s date. It will return Last Day of Previous Month, First Day of Current Month, Today, Last Day of Previous Month and First Day of Next Month respective to current month. Let us see how we can do this with the help of Date Function in SQL Server. Reference: Pinal Dave (. CONVE...
TOTAL PAGES IN THIS WEBSITE
59
SQL Server Question Bank: Error Handling in SQL Server 2005
http://sequelqb.blogspot.com/2011/04/error-handling-in-sql-server-2005.html
SQL Server Question Bank. For on-the-job routines, certifications, interviews . Tuesday, April 19, 2011. Error Handling in SQL Server 2005. The following code represents a basic TRY…CATCH construct. ERROR MESSAGE ();. The following error functions can be used inside a TRY…CATCH construct to get the information about the error that is occurred. ERROR NUMBER() returns the error number. ERROR SEVERITY() returns the error severity. ERROR STATE() returns the error state number. TRY…CATCH with RAISERROR. The f...
SQL Server Question Bank: April 2011
http://sequelqb.blogspot.com/2011_04_01_archive.html
SQL Server Question Bank. For on-the-job routines, certifications, interviews . Tuesday, April 19, 2011. SQL Server 2005 Mainstream support Ended. The Microsoft SQL Server 2005 Mainstream support has ended by 12-April-2011. Therfore the certification exams associated with the product will also be expired. So please note that all the Microsoft SQL Server 2005 exams are scheduled to retire on June 30, 2011. Choose from the following three MCITP certifications on SQL Server 2005. MCTS: SQL Server 2005.
DBA Scripts | Wisdom-Soup
http://www.wisdom-soup.com/blog/category/dba-scripts
Share SQL Server Tips and Tricks and Related News. Category Archives: DBA Scripts. 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.
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...
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.
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...
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...
Technical Blog: March 2013
http://paulmjclark.blogspot.com/2013_03_01_archive.html
This blog is mostly a blog for me with hints to remember those little bits of code etc where ever I am. Please be aware of this when reading any of the posts as they are mainly reminders for me. When I get time I will try to flesh out those sections that are a little ambiguous. Wednesday, 20 March 2013. Last Running Query Based on SPID. Got this from Pinal Dave's Blog. Very useful Blog:. Http:/ blog.sqlauthority.com. SPID ID you wish to query]. SELECT TEXT, USER. Sysdm exec sql text. SELECT TEXT, USER.
TOTAL LINKS TO THIS WEBSITE
3,346
宿迁市网络教研平台
Voyage with Sqkii
A page for us to pen down our thoughts on starting up Sqkii. Page 1 of 3. Older Posts →. Your student card and its untold powers. It’s the time of the year again. Orientation camps, matriculation programmes, module bidding. As fresh-eyed students enter this seemingly unfamiliar phase of life, it is ». 3 reasons why I've not achieved an incredible life. Some time ago, I crafted a bucket-list of things that I will want to accomplish within the next few years. Pen in hand, paper in sight; ». Page 1 of 3.
DBA Blog
SQL Server blocked access to statement OPENROWSET / OPENDATASOURCE. Rating: strong 4.5 /strong out of 2499 votes cast /p '); return false;" class="starinfo" i. 05:29:00 pm, by tom.green. When executing queries using OPENROWSET statement, the following error can appear:. Msg 15281, Level 16, State 1, Line 1. This error appears because Ad Hoc Distributed Queries. Configuration parameter is disabled. To enable Ad Hoc Distributed Queries. Follow the next steps:. Command by enabling the 'show advanced options'.
Blog SQL42
Segunda-feira, 1 de setembro de 2014. Atualizando estatísticas em paralelo - usp update statistics v1. Hoje vou falar de estatísticas de tabelas, mas não de como o SQL Server utiliza ela nos planos, sobre este assunto eu sugiro se inscreverem no Webcast do meu amigo Thiago Alencar neste link. Irei compatilhar hoje uma rotina que utilizo para atualizar as estatísticas das tabelas dos bancos que administro. Antes de iniciar, recomendo também olharem os scripts do Ola Hallengren neste link. 160; parte 02.
SQL Authority with Pinal Dave - SQL Server Performance Tuning Expert
Live Training: Practical Real World Performance Tuning. Weekly Questions and Answers. SQL in Sixty Seconds. SQL Tips and Tricks. Exclusive] Practical Real World Performance Tuning – Live Training Session for Limited Time. I am happy to announce that the new course Practical Real-World Performance Tuning, along with Brent Ozar (blog) is now live. We are accepting the registration for a limited time. This is very unique opportunity to learn Performance Tuning with real-world examples. SQL Tips and Tricks.
SQLblog.com - The SQL Server blog spot on the web
THE SQL Server Blog Spot on the Web. Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in. Add SQLblog.com to. BI with SQL Server. Heading to SQL Sat NYC! I will be speaking at SQL Sat 380 in NYC on the topic of Basic Performance Monitoring with Perfmon. I have delivered this session many times and is usually well attended. The session is geared for the person who has heard of Perfmon but not used it. This. 2 hours, 59 minutes ago by RickHeiges. Want to Learn More About SSIS and Biml?
SQL Concepts
Friday, 5 April 2013. SSDT syntax highlighting disappeared. How I fixed it. I recently struggled with a problem where I seemed to lose the syntax highlighting in Visual Studio 2012 for SSDT projects. Took me a while to stumble onto a solution after multiple reinstalls and almost giving up to rebuild the PC (I like syntax highlighting). The tldr solution is:. Open a Visual Studio Command Prompt (as administrator). The problem (no pretty colours). To list all I had tried;. Patched SQL Server 2012 with SP1.
SQLEDT | Blog Test Data Generator, SQL Schema Compare, SQL Data Compare, SQL Intellisense, Database Navigation, SQL Designer, Script Generator, Quick Find, Quick Filter, and a lot more!
February 14, 2011 08:36 by. Here, we would like to consolidate a list of frequently asked questions, known issues and their resolutions/workarounds:. First, when SQLEDT encounters an unhandled exception, it shows a popup message where you should be able to click on a "View Details" button, like below. If you click the View Details button, you should see more information about the issues, some of which we have tried to summarize below:. Issue 2: "The input stream is not a valid binary format.". Starting w...
Blog SQLexpert | Blog about SQL Server, Business Intelligence, Data Warehousing, ETL, OLAP,…
July 27, 2015. Wakacje, prawie końcówka lipca, a tutaj nagle w piątek wychodzi nowa wersja PowerBI. Bardzo często nazywanego PowerBI 2.0. Od tego momentu można korzystać z wersji darmowej, a także przez 60 dni z wersji zaawansowanej (PowerBI trial). Wraz z PowerBI 2.0, przedstawiony kilka miesięcy temu PowerBI Designer zmienia się w nowe narzędzie PowerBI Desktop, narzędzie [.]. Test Your SQL Database Backup Today! June 18, 2015. Research SQL Server 2016CTP2 7/13. June 17, 2015. June 16, 2015. Rozwój spr...
blog.sqlgeek.pl – From data architect's life
From data architect's life. READY TO DEAL WITH YOUR DATA? Get some tips on how to do that! Rok 2016 dobiega końca. Jaki był ten rok dla mnie? Pełen zmian, nowości i prób, niekiedy dość trudnych. Mógłbym pewnie napisać dość ciekawą książkę w oparciu o swoje przeżycia z roku mijającego i poprzedniego, ale krótko wspomnę tylko o najważniejszych wydarzeniach w moim światku w roku 2016. SQL Server 2016 SP1 – ulepszenia w Reporting Services. SQL Server 2016 – jak Service Pack 1 zmienił świat baz danych. Ostatn...
SOCIAL ENGAGEMENT