sqlserver-online.com
Willkommen bei sqlserver-online.comWillkommen auf der Domain www.sqlserver-online.com!
http://www.sqlserver-online.com/
Willkommen auf der Domain www.sqlserver-online.com!
http://www.sqlserver-online.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Monday
LOAD TIME
0.5 seconds
Holger Schmeling
Holger Schmeling
Bauer●●●●●se 26
Mue●●●hen , DE, 80796
DE
View this contact
Holger Schmeling
Holger Schmeling
Bauer●●●●●se 26
Mue●●●hen , DE, 80796
DE
View this contact
ECS-Webhosting
Ingo Fritz
Volbeh●●●●●●se 11d
Nue●●●erg , DE, 90491
DE
View this contact
BUY YOUR DOMAIN
14
YEARS
5
MONTHS
23
DAYS
PSI-USA, INC. DBA DOMAIN ROBOT
WHOIS : whois.psi-usa.info
REFERRED : http://www.psi-usa.info
PAGES IN
THIS WEBSITE
0
SSL
EXTERNAL LINKS
18
SITE IP
87.119.205.48
LOAD TIME
0.469 sec
SCORE
6.2
Willkommen bei sqlserver-online.com | sqlserver-online.com Reviews
https://sqlserver-online.com
Willkommen auf der Domain www.sqlserver-online.com!
SQL Server Online: November 2010
http://sqlserver-online.blogspot.com/2010_11_01_archive.html
Holger Schmeling about SQL Server. Thursday, November 4, 2010. Multiple statistics sharing the same leading column. SQL Server will not prevent you from creating identical indexes or statistics. You may think that everything is under your control, but have you ever added a missing index that has been reported by the query optimizer, or the DTA? If so, you will certainly have created duplicate statistics. Have a look at the following example:. Create test table with 3 columns. 160; . If the AUTO CREATE S...
SQL Server Online: October 2010
http://sqlserver-online.blogspot.com/2010_10_01_archive.html
Holger Schmeling about SQL Server. Friday, October 29, 2010. Blog Mirror on InsideSQL.org. Two weeks ago Frank Kalis. Invited me to syndicate my blog on the InsideSql platform. That he’s driving for some years now. I gratefully accepted, since I find myself in very good company there. I will also keep this blog active and just mirror my posts to http:/ www.insidesql.org/blogs/holgerschmeling/. You may want to check out blog entries on http:/ www.insidesql.org/blogs/. Posted by Holger Schmeling. Modificat...
SQL Server Online: Configuring a server side trace
http://sqlserver-online.blogspot.com/2011/11/configuring-server-side-trace.html
Holger Schmeling about SQL Server. Tuesday, November 1, 2011. Configuring a server side trace. When I’m after SQL Server performance problems, SQL Server Profiler is still my number one tool. Allthough I know that extended events provide a mor lightweight solution, those are still a bit cumbersome to use (but I’ve seen that we can expect some improvements with SQL Server 2012). And here comes dbo.configureServerSideTrace:. Exec dbo.configureServerSideTrace @traceStatus = 1. TraceID = @traceID output.
Blog | Stefan Kindler
http://www.stefankindler.de/lebenslauf
Microsoft SQL Server Consulting – take advantage of your data. Tel: 0176 / 22501883. Internet: www.stefankindler.de. SQL Server Database Engine (2000,2005,2008,2008 R2,2012). SQL Server Reporting Services (2008, 2008 R2,2012). SQL Server Integration Services (2000,2005,2008,2008 R2,2012). SQL Server Analysis Services ( 2005, 2008, 2008 R2,2012). Windows Server Server 2003 / 2008 / 2008 R2 / 2012. Windows 2000 / XP / Vista / 7 / 8. SQL Server Wartung, Sicherung, Disaster Recovery. Apr 2012 – Heute. Window...
SQL Server Online: April 2010
http://sqlserver-online.blogspot.com/2010_04_01_archive.html
Holger Schmeling about SQL Server. Thursday, April 1, 2010. Boost the performance of your SQL Server. Today I discovered a fascinating, although also weird thing regarding SQL Server Standard Edition. We all know that SQL Server has many of undocumented commands. DBCC makes no difference here. You probably know it as the DBA’s all purpose tool, but what I found by coincidence really puzzled me when I came across it this afternoon. So why not giving it a try? At least today…. Posted by Holger Schmeling.
SQL Server Online: November 2011
http://sqlserver-online.blogspot.com/2011_11_01_archive.html
Holger Schmeling about SQL Server. Tuesday, November 1, 2011. Configuring a server side trace. When I’m after SQL Server performance problems, SQL Server Profiler is still my number one tool. Allthough I know that extended events provide a mor lightweight solution, those are still a bit cumbersome to use (but I’ve seen that we can expect some improvements with SQL Server 2012). And here comes dbo.configureServerSideTrace:. Exec dbo.configureServerSideTrace @traceStatus = 1. TraceID = @traceID output.
SQL Server Online: Multiple statistics sharing the same leading column
http://sqlserver-online.blogspot.com/2010/11/multiple-statistics-sharing-same.html
Holger Schmeling about SQL Server. Thursday, November 4, 2010. Multiple statistics sharing the same leading column. SQL Server will not prevent you from creating identical indexes or statistics. You may think that everything is under your control, but have you ever added a missing index that has been reported by the query optimizer, or the DTA? If so, you will certainly have created duplicate statistics. Have a look at the following example:. Create test table with 3 columns. 160; . If the AUTO CREATE S...
SQL Server Online: February 2011
http://sqlserver-online.blogspot.com/2011_02_01_archive.html
Holger Schmeling about SQL Server. Sunday, February 27, 2011. Calculating SQL Server Data Compression Savings. Unfortunately, SSMS does not offer an option for calculating estimated savings for more than one table or index at once. If you, let’s say, would like to know the estimated storage savings of page level compression for you largest 10 tables, there’s no GUI support in SSMS that will assist you in finding an answer. This is, where the stored procedure. Sp estimate data compression savings. Size wi...
SQL Server Online: January 2011
http://sqlserver-online.blogspot.com/2011_01_01_archive.html
Holger Schmeling about SQL Server. Sunday, January 16, 2011. Exploring SQL Server Blockings and Timeouts. Last Thursday I was giving a presentation about information collection and evaluation of SQL Server Blockings and Timeouts at the regional PASS chapter meeting in Munich. You may download the presentation as well as the corresponding scripts here. Posted by Holger Schmeling. Links to this post. Subscribe to: Posts (Atom). Microsoft SQL Server Library. SQL Server Script Repository.
SQL Server Online: SQL Server Start Time
http://sqlserver-online.blogspot.com/2011/02/sql-server-start-time.html
Holger Schmeling about SQL Server. Tuesday, February 22, 2011. SQL Server Start Time. Have you tried finding out the time, your SQL Server instance has been started? There are some sophisticated solutions, like the one from Tracy Hamlin ( twitter. Which takes advantage of the fact that tempdb is re-created every time, SQL Server starts. Her solution goes like this:. Another answer to the question, I’ve seen sometimes on the internet queries the login time for any of the system processes:. Dm os sys info.
TOTAL LINKS TO THIS WEBSITE
18
Structured Query Language
SQL is a standard interactive and programming language for querying and modifying data and managing databases. FETCH STATUS function in sql server. FETCH STATUS function determines whether FETCH keyword has successfully retrieved a row from the current cursor. The value of @ FETCH STATUS is undefined before any fetches have occurred on the connection. This function can have one of the three values. Syntax of @ FETCH STATUS Function :. Return type of @ FETCH STATUS function is integer. Links to this post.
Help: SQL Server
Sharing my knowlege about SQL Server Troubleshooting Skills. SQL Server 2014 Learning Series. Select * from SQL World where name = ‘Balmukund’. Follow Blog via Email. Enter your email address to follow this blog and receive notifications of new posts by email. Join 2,978 other followers. Select location from world. Help : Get-AzureVM – WARNING: No deployment found in service: ‘domainctrler’. Posted by blakhani on July 9, 2015. And I was welcomed with below message. To a different subscription, I used.
sqlserver-mancilla.blogspot.com
SQL Server
Viernes, 22 de junio de 2012. Reparar Base de Datos. Sobrevivir a la Corrupción a partir de la detección de la Resolución. Su base de datos está dañado. ¿Qué hacer? 191;Qué tan importante son los datos? 191;Sabe usted lo que es realmente malo en la base de datos? 191;Qué significa todo lo que DBCC CHECKDB salida de decir? En caso de que restaurar o reparar? Enviar por correo electrónico. Sábado, 16 de junio de 2012. EJEMPLO PARA REINICIAR EL VALOR AUTO NUMÉRICO. Enviar por correo electrónico. Ing En Sist...
SQL Server Online
Holger Schmeling about SQL Server. Tuesday, November 1, 2011. Configuring a server side trace. When I’m after SQL Server performance problems, SQL Server Profiler is still my number one tool. Allthough I know that extended events provide a mor lightweight solution, those are still a bit cumbersome to use (but I’ve seen that we can expect some improvements with SQL Server 2012). And here comes dbo.configureServerSideTrace:. Exec dbo.configureServerSideTrace @traceStatus = 1. TraceID = @traceID output.
sqlserver-performance-tuning.com
Sqlserver-Performance-Tuning.com
The domain sqlserver-performance-tuning.com may be for sale. Click here to make an offer or call 877-588-1085 to speak with one of our domain experts. This domain may be for sale. Buy this Domain.
IT Consulting Holger Schmeling
IT Consulting Holger Schmeling. Bitte wählen Sie Ihre Sprache. Please select your language.
Data Platform Knowledge Sharing Network | SQLServer-QA.net – A Knowledge Sharing Network…
Data Platform Knowledge Sharing Network. SQLServer-QA.net – A Knowledge Sharing Network…. Archives – [History.SqlServer-QA.net]. Still struggling to upgrade SQL Server 7, 2000 and 2005 instances, need help and support from Microsoft? August 13, 2015. Bull; 0 Comments. Read more →. SQL Gulf #2 at Microsoft Dubai – September 5th 2015. August 12, 2015. Bull; 0 Comments. Read more →. Azure Data Factory, get your data raw materials for manufacturing. August 7, 2015. Bull; 0 Comments. Read more →. July 30, 2015.
SQL Server Articles and Tips and Tricks for Database Administration
Start and Stop SQL Server Services using Command prompt. There are number of different ways to Start and Stop SQL Server services, you can using SQL Server Configuration Manger, SQL Server Mangement Studio, Sqlserver.exe, Command prompt and Windows Console . We will see how to start and stop SQL Server using Command Prompt. You can use Net Start and Net Stop command to Start and . Read more →. SQL Server Database Maintenance. Difference in Features of SQL Server 2012 Vs SQL Server 2014. Read more →.
SQL Server Tips
Thursday, September 06, 2007. The blog has moved to www.sqlblogcasts.com. I will continue posting over there at www.sqlblogcasts.com. Simon Sabon has moved the blog over to www.sqlblogcasts.com. Posted by Alex Kuznetsov @ 8:15 AM. Friday, August 24, 2007. Selecting a random number for each row. Create view wrapped rand view. Select rand as random value. Create function wrapped rand(). Set @f = (select random value from wrapped rand view). Select - your columns- , dbo.wrapped rand() wrapped rand. Table 'I...
