Speeple News Search

Sign Up! | Tags | Domains | Statistics | Options | Advanced Search

Tags » T Sql

Related tags: dba, developer, development, katmai, management, scripts, sql, sql server, sql server 2008, sql server management studio

  1. Abilitare la backup compression per tutti i database dell'istanza

    technet.com » Sql Server Blog di Francesco Diaz - 17 hours ago

    E' possibile, con Sql Server 2008 Enterprise Edition, abilitare la compressione dei backup per salvare spazio su disco o su nastro. Si può specificare la compressione sia per un singolo backup sia di default per tutti …

    Also tagged: amministrazione, sql server 2008

  2. monitorare il database mirroring con T-SQL

    technet.com » Sql Server Blog di Francesco Diaz - Oct 2, 2008

    Di seguito trovate alcune informazioni utili per usare T-SQL per monitorare Sql Server in database mirroring. E' possibile utilizzare la stored procedure sp_dbmmonitorresults (solo nel contesto dell'MSDB) per …

    Also tagged: sql server 2008

  3. Backup and SQL Server diagram opennig problem.

    asp.net » Alexey Zakharov's Blog - Sep 29, 2008

    Very often people who works with SQL Server database get the following error when they trying to open database diagrams after restoring database from back up: Database diagram support objects cannot be installed …

    Also tagged: sql server

  4. To T-SQL? That's not the question!

    asp.net » SergeyS's blog - Sep 29, 2008

    That ASP.NET Forums / SQL Server, SQL Server Express / is getting rather interesting sometimes. Last time it was the puzzle "Not so obvious SELECT" http://forums.asp.net/p/1299660/2535207.aspx#2535207 Lets say that …

    Also tagged: sql server, general software development

  5. T-sql wish

    asp.net » Ricky Datta Blog - Sep 29, 2008

    I wish I could write the following in t-sql : raiserror('Error in procedure %s, statement [%s] stack trace [%s]', 1, 1, @@current_proc_name, @@current_statement, @@stack_trace) where @@current_proc_name = name of …

  6. T-Sql wish - another one

    asp.net » Ricky Datta Blog - Sep 29, 2008

    I wish T-Sql had an Oracle like SGA system buffer which would keep records of - all expensive (CPU, IO) queries made since startup - all full table scans on large and medium tables This way we do not have to hunt for …

  7. T-Sql wish - One more

    asp.net » Ricky Datta Blog - Sep 29, 2008

    TOP (n) operator is very useful. How about MIDDLE (m,n) and LAST(n) operators (server side in Yukon) ? I think ASP.NET programmers would love it.

  8. T-SQL Trivia : What is the fastest way to insert multiple rows from middle tier memory to database table in a single transaction

    asp.net » Ricky Datta Blog - Sep 29, 2008

    Oracle Answer : insert from VARRAY(fixed size) in a special loop [ Bulk Collect Insert ] Sql Server 7/2000 : insert ... from ... in (row 1, row 2, ...) - dynamic sql required. Yukon team - Can you do better than …

  9. Microsoft Sql Server 2008 February 2008 CTP Released

    asp.net » Share Intelligence - Sep 29, 2008

    Well even though the full release of SQL Server 2008 has been pushed to late second half of the year, the latest CTP was delivered on time. This is the first feature complete CTP released. It includes increased …

    Also tagged: reporting services, sql server 2008

  10. How To: Create DB Unit Test With Team System

    How To: Create DB Unit Test With Team System

    microsoft.co.il » Shai Raiten - Sep 11, 2008

    How To: Create DB Unit Test With Team System In my last post I talked about What Is Database Unit Testing and Why? , in this post I'll show how to create DB Unit Test. Building on the AdventureWorks sample project …

    Also tagged: team system, sql, testing, unit test

1  2  3  4  5  6  7