sqldotnet.com
Sql Dot NETA .NET developer writing about SQL and more. Things learned the hard way, neat tips and tricks that get the job done.
http://www.sqldotnet.com/
A .NET developer writing about SQL and more. Things learned the hard way, neat tips and tricks that get the job done.
http://www.sqldotnet.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Saturday
LOAD TIME
3.8 seconds
16x16
PAGES IN
THIS WEBSITE
16
SSL
EXTERNAL LINKS
1
SITE IP
188.226.132.210
LOAD TIME
3.813 sec
SCORE
6.2
Sql Dot NET | sqldotnet.com Reviews
https://sqldotnet.com
A .NET developer writing about SQL and more. Things learned the hard way, neat tips and tricks that get the job done.
sqldotnet.com
About | One developer's SQL blog
http://sqldotnet.com/about
One developer's SQL blog. A NET developer writing about SQL. I have started this blog to put down things i found out about the hard way, small tricks that get the job done in a neat way, jobs that i have done and enjoyed or nice stories from experience. Another reason for starting blogging was to actually write down stuff I use from time to time, and every time i need them again, I have to look up for the scripts or things that i want to share with my colleagues and techy friends. Follow me on twitter.
Db Development | One developer's SQL blog
http://sqldotnet.com/category/db-development
One developer's SQL blog. A NET developer writing about SQL. Category Archives: DB Development. Add UNIQUE constraint WITH NOCHECK? Not really …. Ever wanted to add a UNIQUE constraint WITH NOCHECK? Maybe you had some duplicates in your data, fixed the code, but you cannot remove the duplicates, or maybe it’s a “temporary” thing. Read more ». Passing a DataTable as table parameter from C# to stored procedures using table type. Table size growth when converting columns – VARCHAR to INT. Read more ».
Who am I ? | One developer's SQL blog
http://sqldotnet.com/about/who
One developer's SQL blog. A NET developer writing about SQL. My name is Horia Negrila, and I’m full-time .NET developer since 2006, building desktop applications using WPF (mvvm), WCF (Agatha) and MSSQL. In spare time, i build SSRS reports, doing database work like data cleansing, database maintenance and performance improvements, training new folks into SQL when needed or advising / reviewing database developments. Follow me on twitter. Subscribe to this blog. Add UNIQUE constraint WITH NOCHECK?
Tsql | One developer's SQL blog
http://sqldotnet.com/category/tsql
One developer's SQL blog. A NET developer writing about SQL. Add UNIQUE constraint WITH NOCHECK? Not really …. Ever wanted to add a UNIQUE constraint WITH NOCHECK? Maybe you had some duplicates in your data, fixed the code, but you cannot remove the duplicates, or maybe it’s a “temporary” thing. Read more ». Automating restores for Ola Hallengren backup solution. While going through Brent Ozar’s 6-Month DBA Training Plan. Read more ». Safe exit from WHILE loop using # global temp tables. Read more ».
Dba | One developer's SQL blog
http://sqldotnet.com/category/dba
One developer's SQL blog. A NET developer writing about SQL. Automating restores for Ola Hallengren backup solution. While going through Brent Ozar’s 6-Month DBA Training Plan. I got myself a good challenge quite fast, after reading “Automating Restores” – to automate restores on backups taken using Ola Hallengren Backup Solution. Read more ». Follow me on twitter. Subscribe to this blog. Add UNIQUE constraint WITH NOCHECK? Not really …. Automating restores for Ola Hallengren backup solution.
TOTAL PAGES IN THIS WEBSITE
16
SQLDoctor – SQL Expert Blog | Get Expert on SQL
SQLDoctor – SQL Expert Blog. Get Expert on SQL. Query to identify compressed tables in SQL Server 2012. July 7, 2013. I have been looking for options to list all my compressed tables through a query. SELECT OBJECT NAME(object id) AS [ObjectName] FROM sys.partitions WHERE OBJECTPROPERTY(object id, ‘ismsshipped’) = 0 AND data compression 0. Suppose if you want to find all the tables which are not compressed, you can use something like this. The other option is. February 20, 2013. I am going away from my to...
SQLdocu - Documentation of SOL - Startseite
Wenn du nicht weisst was SQL ist, dann starte mit diesem Link. Hier findest du die wichtigsten Grundlagen von Datenbanken bzw. SQL. Hier findest du die wichtigsten Datentypen von Mysql, Oracle und Informix. Hier findest du alle SQL Befehle samt Benutzerverwaltung. Du solltest mit SQL vertraut sein, wenn du diese Seiten liest. Hier wird auf Operatoren eingegangen (z.B: =, , =, LIKE, usw.) die von SQL unterstützt werden. Hier gehen wir auf Funktionen (MAX, MIN, TRIM, SUBSTRING, usw.) ein.
SQLDog Utility Suite | 7 Tools in 1 for SQL Server
Lite Version 100% Free. SQL Server 2005 and 2008 support. XCopy Deployment (No Installation). Find us on Facebook. Follow us on Twitter. Version 3.1.2. Submit a Feature Request.
SQL Dojo - Welcome to Orchard!
You've successfully setup your Orchard Site and this is the homepage of your new site. Here are a few things you can look at to get familiar with the application. Once you feel confident you don't need this anymore, you can remove it by going into editing mode. And replacing it with whatever you want. First things first - You'll probably want to manage your settings. And configure Orchard to your liking. After that, you can head over to manage themes to change or install new themes. Or managing your menus.
دانستنیهایی از دات نت و sql
دانستنیهایی از دات نت و sql. SQL Server 2000 Basic Installation. مدیریت SQL Server 2000 در ۱۵ دقیقه از هفته: Basic Installation -. به سری دوم از این سری مقالات خوش آمدید! در مقاله هفته پیش نگاهی به ورژنها و پیش نیازهای نصب SQL Server 2000 داشتیم. در این مقاله نگاهی داریم به چگونگی انجام ابتدایی ترین و اصلی ترین نحوه نصب. SQL Server 2000. عناوین این مقاله عبارتند از :. مرحله پیش از نصب. مروری بر مراحل نصب. مرحله پیش از نصب. لیست کارهایی که می بایست قبل از نصب SQL Server 2000 انجام دهید :. 4 در اینجا پیغام...
Sql Dot NET
One developer's SQL blog. A NET developer writing about SQL. Add UNIQUE constraint WITH NOCHECK? Not really …. Ever wanted to add a UNIQUE constraint WITH NOCHECK? Maybe you had some duplicates in your data, fixed the code, but you cannot remove the duplicates, or maybe it’s a “temporary” thing. Read more ». Automating restores for Ola Hallengren backup solution. While going through Brent Ozar’s 6-Month DBA Training Plan. Read more ». Safe exit from WHILE loop using # global temp tables. Read more ».
SQLDoubleG | Are you a real SQL G?
Our Google plus page. ParseInt(jQuery('#bwg current image key').val() - iterator() % data.length : data.length - 1, data); return false;". Get the data and RUN! Playing with Azure, Stretching Databases. In-Memory logging, much cooler than disk based. In-Memory NonClustered Indexes, much cooler than disk based. Database Design Matters, Real World Scenario. Database Design Matters, RTO and Filegroups. Playing with Azure, Stretching Databases. In-Memory logging, much cooler than disk based. Don’t get ...
SQL Download
SQL Server Activity Monitoring and Logging Stored Procedure. If you have used the sp who or sp who2 script before, you will find sp whopro very helpful, sp whopro is versatile and easy to use. You can also find info about the script in our sp whopro videos. Sp whopro lets you monitor the current activity of a SQL Server Instance and at the same time allows you to save the activity to database for later analysis. You can collect data related to. Sql, wait, block, locks, limited'. Active, blocking, save'.
SQLDownSouth
Monday, January 31, 2011. SQL Lunch - Introduction to Change Data Capture. Join me tomorrow for a little CDC. 47-Introduction to Change Data Capture. 160; https:/ www.livemeeting.com/cc/usergroups/join? 2/1/2011 11:30:00 AM CST. 47-Introduction to Change Data Capture. Talk to you soon,. Patrick LeBlanc, MVP. Founder, www.SQLLunch.com. Tuesday, January 18, 2011. SQL Lunch - Building a Performance Point Dashboard. Don't forget to attend the SQLLunch tomorrow. Adam Jorgensen, SQL Server MVP. So, what's next...
SQLDownUnder- SQL Server and Business Intelligence Training Mentoring
Simply the best SQL Server and BI training available. Together we can deliver successful projects. The ever-popular SQL Down Under podcast, reviews and many other resources. SQL Down Under are a team of SQL Server and Business Intelligence specialists operating from Australia and providing global offerings. SQL Down Under are master SQL Server trainers and mentors. Why learn about SQL Server second-hand? Phone: 1300 SQL SQL (1300 775 775) l International 61 1300 775 775 l Fax: 61 3 8676-4913.
SQLDownUnder- SQL Server and Business Intelligence Training Mentoring
Simply the best SQL Server and BI training available. Together we can deliver successful projects. The ever-popular SQL Down Under podcast, reviews and many other resources. SQL Down Under are a team of SQL Server and Business Intelligence specialists operating from Australia and providing global offerings. SQL Down Under are master SQL Server trainers and mentors. Why learn about SQL Server second-hand? Phone: 1300 SQL SQL (1300 775 775) l International 61 1300 775 775 l Fax: 61 3 8676-4913.
SOCIAL ENGAGEMENT