sql-learning.blogspot.com
SQL Developer Journeying to DBAThis blog is for SQL Developers who would like to tranform themselves to DBA
http://sql-learning.blogspot.com/
This blog is for SQL Developers who would like to tranform themselves to DBA
http://sql-learning.blogspot.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.5 seconds
16x16
32x32
64x64
128x128
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
0
SITE IP
172.217.3.33
LOAD TIME
0.453 sec
SCORE
6.2
SQL Developer Journeying to DBA | sql-learning.blogspot.com Reviews
https://sql-learning.blogspot.com
This blog is for SQL Developers who would like to tranform themselves to DBA
sql-learning.blogspot.com
SQL Developer Journeying to DBA: Find Number of Days in a Given Month
http://sql-learning.blogspot.com/2013/07/find-number-of-days-in-given-month.html
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Monday, July 1, 2013. Find Number of Days in a Given Month. How many lines of code do you need to write to get number of days in a given month , there is no handy function available in SQL Server which does the job. Say 12 If statements or combine Month which has 30 and 31 with just IF Statements . And how about February which may have 28 or 29 depending on leap year or not. Started career as a ...
SQL Developer Journeying to DBA: July 2010
http://sql-learning.blogspot.com/2010_07_01_archive.html
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Friday, July 30, 2010. Avoid Functions on Indexed Columns. Many of us have the have the habit of doing this common mistake of having functions over column names, which makes the column take a totally new value, and by which we make. SQL Server not use the indexes which results in poor performance of a query. SET STATISTICS TIME OFF. DROP TABLE TEST FUNCTION PERF. Create a table with 3 columns.
SQL Developer Journeying to DBA: COUNT(*) Versus IF EXISTS.
http://sql-learning.blogspot.com/2012/08/count-versus-if-exists.html
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Monday, August 27, 2012. COUNT(*) Versus IF EXISTS. This style of coding is often followed by many developers where in we check whether records are present in table by using SELECT * or COUNT(*).But the question is are we using the. Right method to instead for just checking existence of records and the answer is no. As always let us see an example to understand this better:. SET STATISTICS IO OFF.
SQL Developer Journeying to DBA: Dynamic Statements - sp_executesql Vs EXEC
http://sql-learning.blogspot.com/2010/09/dynamic-statements-spexecutesql-vs-exec.html
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Tuesday, September 7, 2010. Dynamic Statements - sp executesql Vs EXEC. Dynamic Statements are ineffective to use as SQL Server would not be able to determine a execution during compilation time and so SQL Server would create the execution plan. Each and every time when such statements are executed. As always let us see an example to understand this better:. DROP TABLE TEST SYS CACHE. SELECT 'AB...
SQL Developer Journeying to DBA: February 2013
http://sql-learning.blogspot.com/2013_02_01_archive.html
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Thursday, February 7, 2013. Generate HTML reports from SQL Server. Do you know generating HTML reports via SQL Server is so simple using Web Assistant Procedures , please have a look at below steps to try out the same. To enable Web Assistant via sp configure to use that feature. Sp configure 'Web Assistant Procedures' ,1. Sp configure 'xp cmdshell' ,1. Xp cmdshell 'md C: report'. So go ahead wi...
TOTAL PAGES IN THIS WEBSITE
19
SQL-Kevin
Thursday, December 15, 2011. I've now moved to http:/ akawn.com/blog. And will no longer be using or updating this SQL-Kevin blog. Thursday, September 29, 2011. Error: 18456, Severity: 14, State: 58. Recently I was alerted to the following error that was caused when a legacy application was attempting to use an ODBC connection to connect to a SQL Server. Login failed for user ' . Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. The steps t...
sql-knowledge-base.blogspot.com
SQL Knowledge Base
Thursday, 11 September 2008. You use a cursor to fetch rows returned by a query. You retrieve the rows into the cursor using a query and then fetch the rows one at a time from the cursor. You typically use the following five steps when using a cursor:. 1 Declare variables to store the column values for a row. 2 Declare the cursor, which contains a query. 3 Open the cursor. 4 Fetch the rows from the cursor one at a time and store the column values in the variables. 5 Close the cursor. The FROM clause of a...
SQLdays Konferenz 2015
Empfang ab 08:30 Uhr. Alois-Schließl-Platz 1, 85435 Erding. Buchen Sie jetzt und sparen Sie durch unsere Early-Bird Angebote. Blockbuster SQL Server 2014. Was Hollywood kann, können wir schon lange - und besser. Wir nehmen die größten SQLdays. Stars und bieten 2 Tage. Lang beste Unterhaltung. Statt einen 150 Minuten. Monumentalfilm liefern wir über 30 Stunden. Im Laufe von 2 Tagen können Sie so viel Wissen mitnehmen, wie Sie tragen können. Es gibt keine Mengenbeschränkung. Da schau, ein Studierter! Hochk...
T-Sql, PL/SQL, MySQL, kurs online, bazy danych, książki
SQL-kursy.pl kurs sql. Strona na temat baz danych. 8226;Kurs MySQL podstawy. 8226;MySQL UPDATE, DELETE, INSERT, ALTER TABLE. 8226;MySQL JOIN, INNER, OUTER. UNION. 8226;MySQL tworzenie widoków. 8226;MySQL tworzenie procedur i funkcji, zmienne. 2 Łączenie tabel w sql. 3 Tworzenie tabel w sql. 4 Tworzenie perspektyw w sql. 5 Funckje agregujące w sql. 6 Tworzenie Procedór i funckji. 7 Modyfikacja dancyh w sql. 8 Funckje w sql i transpozycja. Instalacja MS SQL SERVER 2008. 8226;Użycie Common Table Expressions.
Язык запросов SQL. SQL запросы. Запросы sql примеры
Структурированный язык манипулирования данными SQL. Структурированный язык запросов SQL. Что такое язык запросов SQL? Используется программистами наиболее широко. Причиной тому является повсеместное распространение динамических веб сайтов. Как правило, такие ресурсы имеют гибкую оболочку. Но основной костяк такого сайта составляют базы данных. Если вы начинающий программист, вы просто обязаны освоить структурированный язык запросов SQL. Зачем нужно знать язык запросов SQL? Освоив язык запросов sql. Вы см...
SQL Developer Journeying to DBA
SQL Developer Journeying to DBA. This blog is for SQL Developers who would like to tranform themselves to DBA. Tuesday, July 2, 2013. Find SQL Services running on a Instance. Dm server services is a useful system view which provides detail about SQL Services running on a instance and other good feature is that it shows even the cluster node on which SQL Server services are running. Startup type desc,. Last startup time,. Is clustered, cluster nodename. FROM sys.dm server services. Monday, July 1, 2013.
Untitled Document
SQL-Ledger ERP
SQL-Ledger is a webbased ERP system which runs on any *NIX, Mac or Windows platform. Accounting data is stored in a SQL database server, for the display any text or GUI browser can be used. Built with freely available software so you are never locked in. Written in easy readable perl code. Intuitive interface so the learning curve is kept to a minimum. After all who wants to spend hours learning a new program. Installation is easy, it only takes a few minutes to install on most systems.
start [sql-ledger get started]
Sql-ledger demo multilingual tutorial manual. Onlinedemo : screencasts : multilingual. Demo is free from tasks of administration. Menu is for case of working straigth forward in sales and purchase. prepairing system for specific conditions is not aim of demo system. But therefore are several levels of customimizing opportunities. Don*t hesitate to ask. X6d;ailto:cs@ossps.de. Starttxt Last modified: 2015/06/11 13:26 by h0cpgxrmxm.
SQL-Ledger - Lizenzkostenfreien Open-Source ERP-Lösung | Home
SQL-Ledger - Das Open Source ERP System. SQL-Ledger ist ein komplettes Buchhaltungsprogramm (ERP-System). Die Buchungen werden in einer offenen SQL-Datenbank (PostgreSQL) gespeichert. Für den Zugriff wird lediglich ein Webbrowser benötigt. Dank der Stücklisten-Funktion können auch selbst produzierte Artikel ans Lager genommen werden. Wenn ein Stücklistenartikel verkauft wird, werden die entsprechenden Einzelpositionen am Lager automatisch angepasst. Uuml;bersetzungen der Artikel und Templates sind so fle...
Untitled Document
