Blogs1 - 10 of 4,008 recent posts for tag:SQL
10
Feb
2012
abc amber 3 01 serial

17 hours ago by admin

Name File: abc amber 3 01 serial Just downloaded: 35002

Anwarul Warez Blog - anwarul-islam.com

Enable CLR on SQL Server

18 hours ago by Rudy

I ran into a case where CLR was disabled on one of my servers. If you don’t know what CLR is, in a nutshell, you can run VB or C# code on your SQL Server. Here is a sample CLR procedure from MSDN that calculates sales taxes. But, back to enabling CLR on your SQL Server. There is a simple command you ...

Rudy Rodarte . com - rodolforodarte.com · 1 reference

Index Creation In SQL Azure

19 hours ago by Richard Franzen

Doing some testing in SQL Azure, I found that table creation is a slightly different beast. Simply using a SQL table creation script generated by the SQL Server Management Studio does not translate into the Azure environment. I needed to make some modifications first to get the code working correctl ...

Software Development for ... - softwaredevelopmentforecm.wordpress.com · 3 references

How to build Table-Valued Parameter that is used in SQL Stored Procedures

21 hours ago by Bonnie

Table-Valued Parameters Table-valued parameters have two primary components: a SQL Server type and a parameter that references that type. Benefits: 1. Do not acquire locks for the initial population of data from a client. Facilitate bulk inserts very efficiently 2. Are Strongly Typed 3. Provide a si ...

Eddie and Bonnie's Random ... - bonniepan02.wordpress.com · 1 reference

Transformando textos em linhas

21 hours ago by forinti

Uma função que não se acha no SQL é a split(). Por exemplo, para transformar o string '12,34,56,78,90' em linhas de uma consulta, podemos escrever um pequeno bloco de PL/SQL no Oracle. No entanto, quero usar apenas o SQL. Minha solução é a seguinte: select trim(trailing ',' from item) from ( select ...

Alquerubim - alquerubim.blogspot.com

Restore Full Database from multiple backup files - SQL Server

1 day ago by Paresh Prajapati - SQL DBA

As I know database restoration is a best practice on periodically to check and verify database backup copies and issues while restoration due to any stuffs. I have wrote for the database backups as how can we perform full database backup completely and split in to multiple files to reduce IO and tim ...

sqlIdeas - paresh-sqldba.blogspot.com

Tester / Level 2

1 day ago by Zylog Canada Recruiting

Zylog delivers top jobs to top talent. We are currently seeking experienced professionals for exciting new opportunities and career advancement. Zylog represents hundreds of client companies for both contract and permanent positions. New jobs are being filled every day and our experienced profession ...

Zylog Canada Recruiting - topjobscanada.blogspot.com · 1 reference

Top 10 Performance Tips for SQL Server

1 day ago by mitch vanhelden

Found a blog with some tips for SQL Server Performance Tuning. the 10 tips helps you start on performance tuning in Microsoft SQL Server Tuning. For the complete explanation, I refer to the original blog Here's a short overview of the tips: Stop waiting around Check the SQL wait statistics to recogn ...

Mitch Vanhelden - mitchvanhelden.blogspot.com

Bulk Insert Yöntemi

1 day ago by Onur Gazioğlu

Büyük veriler ile çalışan yazılımcılar çok fazla kaydı bir tabloya yazarken ederken klasik yöntemler ile kod yazıldığında çok uzun süren döngülere girildiğini az çok bilirler. Örneğin bir döngü ile tabloya 1000 kayıt 1 saniyede yazılırken 10000 kaydın lineer bir artış ile 10 saniyede yazılması bekle ...

Club Crema - clubcrema.com · 1 reference

Lateral SQL Injection: Neue Erkenntnisse

1 day ago by Uwe M. Küchler

SQL Injection ist ein Verfahren, über eine Anwendung, die den Zugriff auf die Datenbank bereitstellt, eigene Datenbankbefehle einzuschleusen. Jeder Entwickler, der sicherheitsrelevante DB-Anwendungen schreibt und dabei dynamisch generiertes SQL einsetzt, sollte mit diesem Angriffsszenario und den Ge ...

Oraculix - oraculix.wordpress.com · 2 references

Previous1234567