sqlinsider.pl
SQL BlogBlog poświęcony zagadnieniom związanym z językiem SQL i silnikiem bazodanowym Microsoft SQL Server.
http://www.sqlinsider.pl/
Blog poświęcony zagadnieniom związanym z językiem SQL i silnikiem bazodanowym Microsoft SQL Server.
http://www.sqlinsider.pl/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Thursday
LOAD TIME
0.8 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
11
SITE IP
74.125.29.121
LOAD TIME
0.765 sec
SCORE
6.2
SQL Blog | sqlinsider.pl Reviews
https://sqlinsider.pl
Blog poświęcony zagadnieniom związanym z językiem SQL i silnikiem bazodanowym Microsoft SQL Server.
sqlinsider.pl
marca 2015 | SQL Blog
http://www.sqlinsider.pl/2015_03_01_archive.html
Poniedziałek, 30 marca 2015. 7 powodów dlaczego nie powinno się używać SELECT * FROM. Nie tak dawno temu, ktoś zadał pytanie dlaczego nie powinno się używać konstrukcji SELECT * FROM. Większość osób po prostu zwraca uwagę na to, że nie powinno się tego robić, nie wspominając dlaczego tak jest. Mam nadzieję, że te kilka poniższych punktów pozwoli Wam lepiej zrozumieć dlaczego po prostu tego typu zapytania nie powinny być tworzone,. 4 Większa ilość fizycznych i logicznych operacji odczytu. SQL Server z...
Synonimy | SQL Blog
http://www.sqlinsider.pl/2015/04/synonimy.html
Wtorek, 28 kwietnia 2015. Tworzenie kilku wersji procedury składowanej, dla poszczególnych środowisk nie jest optymalnym podejściem. Z pomocą przychodzą jednakże synonimy. Jest to jedna z funkcjonalności, które nie są prawdopodobnie bardzo powrzechnie wykorzystywane. Tworzenie synonimu jest bardzo proste. Założmy, że mamy serwer połączony o nazwie MYSERVER oraz instancji SQL2012. Na serwerze znajduje się baza danych MyRemoteDatabase i zawiera ona tabelę Products. Synonim dla tego typu obiektu...Synonimy,...
O mnie | SQL Blog
http://www.sqlinsider.pl/p/o-mnie.html
Nazywam się Grzegorz Gazda. Jestem programistą .NET i od 2007 roku pracuję z relacyjnymi bazami danych opartymi na SQL Server. Swoją przygodę z tym produktem rozpocząłem pracując na wersji SQL Server 2000. Od tego czasu pracowałem na wersjach 6.5, wspomnianej 2000, 2005, 2008/2008R2, 2012 i 2014. Jestem pasjonatem tego produktu a w szczególności interesują mnie zagadnienia związane z optymalizacją zapytań, projektowaniem baz danych oraz strategiami indeksowania. Optymalizacja cz.1 – Indeksy.
września 2014 | SQL Blog
http://www.sqlinsider.pl/2014_09_01_archive.html
Wtorek, 9 września 2014. Indeks klastrowy - prześwietlenie cz 2. W poprzednim wpisie pokazałem w jaki sposób obecność dodatkowych indeksów i predykatów użytych w zapytaniu może wpłynąć na kolejność rekordów zwróconych z tabeli na której istnieje indeks klastrowy. I co najważniejsze jedynym sposobem by dane zwrócone zostały w oczekiwanej kolejności jest użycie klauzuli ORDER BY w zapytaniu. Poniższy skrypt tworzy sekwencje, tabele oraz unikalny indeks klastrowy gdzie duplikaty są ignorowane. AllocationSeq...
kwietnia 2015 | SQL Blog
http://www.sqlinsider.pl/2015_04_01_archive.html
Wtorek, 28 kwietnia 2015. Tworzenie kilku wersji procedury składowanej, dla poszczególnych środowisk nie jest optymalnym podejściem. Z pomocą przychodzą jednakże synonimy. Jest to jedna z funkcjonalności, które nie są prawdopodobnie bardzo powrzechnie wykorzystywane. Tworzenie synonimu jest bardzo proste. Założmy, że mamy serwer połączony o nazwie MYSERVER oraz instancji SQL2012. Na serwerze znajduje się baza danych MyRemoteDatabase i zawiera ona tabelę Products. Synonim dla tego typu obiektu...Synonimy,...
TOTAL PAGES IN THIS WEBSITE
19
Uncategorized | mironiasty is coding
http://mironiasty.net/category/uncategorized
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. I’m working currently on few more or less interesting project and I thought that I could share with my experience and code with the world. Maybe it will be useful for someone someday :). Teensy – why you shouldn’t plug anything to your USB port. Teensy for beginners – playing with keyboard. Teensy for beginners (like me) – first step. Why I don’t like Visual Basic.NET Part #2. Proudly powered by WordPress.
Miron Pawlik | mironiasty is coding
http://mironiasty.net/author/miron
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. Author Archives: Miron Pawlik. Teensy – why you shouldn’t plug anything to your USB port. We have a Teensy. And we know how to write program that could type something. What we can do with that? We can input some system commands. Most simple example would be to open notepad and then type something in it. Teensy for beginners – playing with keyboard. We have Teensy and know how to program it. Continue reading →. Teensy...
April | 2014 | mironiasty is coding
http://mironiasty.net/2014/04
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. Monthly Archives: April 2014. How to speed up build time for F# project with SQL TypeProvider. It is good to read documentation. There is so many useful information that might save a lot of time…. Of course it is, it is F#! Type provider, there two additional parameters that could be use:. Teensy – why you shouldn’t plug anything to your USB port. Teensy for beginners – playing with keyboard.
F# | mironiasty is coding
http://mironiasty.net/category/f
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. How to speed up build time for F# project with SQL TypeProvider. It is good to read documentation. There is so many useful information that might save a lot of time…. Of course it is, it is F#! Type provider, there two additional parameters that could be use:. Dump data from SQL to CSV (or other format) with F#. Here is description of how it is done: (or you can just look on full source code. Continue reading →.
CakePHP | mironiasty is coding
http://mironiasty.net/category/php/cakephp
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. Models autoloading in CakePHP. CakePHP convention require to declare in each controller which model we want to use in it by declaring. Uses = array('Model1', 'Model2');. App: import('Model', 'ModelName'); $this- ModelName = new ModelName();. But there is another option: I could write some code that will auto load required models, when they are needed. You have to add below function to your AppController. In similar w...
VB.NET | mironiasty is coding
http://mironiasty.net/category/vb-net
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. Category Archives: VB.NET. Why I don’t like Visual Basic.NET Part #2. As I have mentioned some time ago – I’m not a fan of VB.NET. Here is another example why:. Let say we have such function:. At first look everything looks fine. But, why there 27 as result, and not 22? Oh, that’s obvious. Someone declared CalculateTax as:. C# made it easier, you can either use ref. Let’s take Interfaces for example:. Public Class Fi...
C# | mironiasty is coding
http://mironiasty.net/category/c
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. As they say: you live and learn. Some time ago I wrote about why I don’t like VB.NET. Where I was complaining about strange VB.NET behaviour with implementing interfaces. And recently I found out that in C# there is also something called Explicit Interface Implementation. So if we take example from my previous post:. And then we can call it:. Public class Program { public static void Main() { Console.WriteLine(As...
PHP | mironiasty is coding
http://mironiasty.net/category/php
Just another lazy programmer's blog. Skip to primary content. Skip to secondary content. Models autoloading in CakePHP. CakePHP convention require to declare in each controller which model we want to use in it by declaring. Uses = array('Model1', 'Model2');. App: import('Model', 'ModelName'); $this- ModelName = new ModelName();. But there is another option: I could write some code that will auto load required models, when they are needed. You have to add below function to your AppController. In similar w...
TOTAL LINKS TO THIS WEBSITE
11
宿迁燃气热水器|洋河燃气热水器__宿迁洋河新城庄岩电器城
关于我们 / ABOUT US. 新闻中心 / NEWS CENTER. 客服热线 0527-84926998 业务咨询 0527-84926998 传真 0527-84926998 邮箱 web@zhimd.com. 版权所有 苏ICP备14002765号 宿迁燃气热水器,洋河燃气热水器.
Microsoft SQL Server DBA with SQLPASS volunteer information
Allen Kinsel - SQL DBA. SQL Server, PASS, and other data mishaps. Send me an email! I Spout off about Bacon. T-SQL Tuesday – Giving back to the SQL Community in 2015. Posted by Allen Kinsel. This months TSQL Tuesday #61 is hosted by Wayne Sheffield on Giving Back to the SQL Server Community. An interesting topic given the season and something that is near and dear. Here’s his original post http:/ blog.waynesheffield.com/wayne/archive/2014/12/t-sql-tuesday-61-giving-back/. Posted by Allen Kinsel. I’...
SQL Insanity | Just another WordPress site
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! Welcome to WordPress. This is your first post. Edit or delete it, then start blogging! This is an example page. It’s different from a blog post because it will stay in one place and will show up in your site navigation (in most themes). Most people start with an About page that introduces them to potential site visitors. It might say something like this:. 8230;or something like this:. I’m a bike messenger by day,...
SQL Inside :: Export 옵션 설명
변화를 꿈꾸는 개발자 제이제이 입니다. Posted by Master.JeyJey. 한번에 가져오는 데이터량은 옵션에 따라 달라지는데 다음과 같습니다. 다음은 exp 툴을 이용할 경우입니다. EXP scott/xxxx@bbbb FILE='a.dmp' RECORDLENGTH=64000 GRANTS=N INDEXES=Y ROWS=Y CONSTRAINTS=Y TRIGGERS=Y COMPRESS=Y DIRECT=Y CONSISTENT=N STATISTICS=ESTIMATE TABLES=(XXXXXX). 옵션중에 RECORDLENGTH가 있습니다. 이 값에 따라 한번에 가져오는 데이터량이 달라집니다. 물론, 그 값이 클수록 데이터 전송 속도는 빨라지게 됩니다. 그러나, 이 옵션은 DIRECT=Y 일 경우에만 해당되고, DIRECT=N 인 경우에는 BUFFER라는 키워드가 이를 대신하게 됩니다. DIRECT 모드가 사용될때는 RECORDLENGTH 키워드에 지정된 값이 사용되고,.
Coming Soon - Future home of something quite cool
Future home of something quite cool. If you're the site owner. To launch this site. If you are a visitor. Please check back soon.
SQL Blog
Wtorek, 28 kwietnia 2015. Tworzenie kilku wersji procedury składowanej, dla poszczególnych środowisk nie jest optymalnym podejściem. Z pomocą przychodzą jednakże synonimy. Jest to jedna z funkcjonalności, które nie są prawdopodobnie bardzo powrzechnie wykorzystywane. Tworzenie synonimu jest bardzo proste. Założmy, że mamy serwer połączony o nazwie MYSERVER oraz instancji SQL2012. Na serwerze znajduje się baza danych MyRemoteDatabase i zawiera ona tabelę Products. Synonim dla tego typu obiektu...Synonimy,...
sqlinsiders.com - Registered at Namecheap.com
This domain is registered at Namecheap. This domain name has expired - renewal instructions. This domain is registered at Namecheap. This domain name has expired - renewal instructions. The Sponsored Listings displayed above are served automatically by a third party. Neither Parkingcrew nor the domain owner maintain any relationship with the advertisers.
SQL Insiders.NET
Treinamento online e presencial. Criar uma conta nova. 2015 Todos os direitos reservados.
Insight to SQL
Certified Woman-Owned Small Business. Welcome to SQL Insight. We do SQL Right! Along with Sharepoint BI 2013 and the Microsoft Stack! SQL Insight is a Certified Woman-Owned business (Federal and State of Florida). Offering computer services to government and commercial clients. Our staff is highly qualified in the areas of Business Intelligence, Database Services, Custom Report Solutions, Database Conversion/Migration, and Database Performance Tuning. One of our specialties is Analysis Services (SSAS):.
Sql Server Insights
In this blog I will tell you about some issues I had to face as a SQL Server DBA and what were the insights I gained from each. March 19, 2009. Compare varchar and int - Implicit vs Expclicit conversions. While working on a query I stumbled across. The following issue completely. By mistake, but I believe it is worth mentioning. I had a table with a varchar. Column that actually contained numbers, or so I believed. In my query as a result of lack of attention I wrote the following predicate. Server conve...
SQL Installer.NET - Home
Project Hosting for Open Source Software. By clicking Delete, all history, comments and attachments for this page will be deleted and cannot be restored. Change History (all pages). Is a toolset which assists in the development, deployment, and maintenance. Of applications which interface with a relational database management system (RDBMS). It supports a wide range of RDBMS products including: Microsoft SQL Server * Oracle * IBM DB2 * PostGreSQL * Firebird SQL * MySQL * SQLite * Teradata.
