sql-server-performance.com

Please wait for loading...




      (1118):

    /
     1  ~ 2014 oct 03sql server performanceSQL Server PerformanceDBA, developer and performance tuning articles and tips on SQL Server , including versions 2008, 2005 and 2000. ‎General SQL Server ... - ‎Using Performance Monitor - ‎General Tips on Optimizing
     1  ~ 2014 sep 30sql server performance tuningSQL Server Performance - SQL Server Performance TuningDBA, developer and performance tuning articles and tips on SQL Server , including versions 2008, 2005 and 2000.
     2  +1 2014 sep 25ssas ntext fieldVARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types Despite NTEXT and TEXT being deprecated in SQL Server for some time they ... Note that since the data type of the student_name column is NTEXT the query ...
     2  +5 2014 sep 02sql server performance tipsSQL Server Tips - SQL Server PerformanceGeneral SQL Server Performance Tuning Tips ... SQL Server 2000/2005 Indexed View Performance Tuning and Optimization Tips  ...
     2  +1 2014 aug 10check litespeed statusLiteSpeed backup status | SQL Server Performance ForumsHi, I use the below script to take litespeed backup and restore. ... need to be used to view the status like SQL native backup STATS parameter.
     3  +3 2014 oct 03sql performance monitorUsing Performance Monitor - SQL Server PerformanceAs you probably already know, SQL Server is very good at tuning itself. It has the ability to monitor itself, and through a feedback loop, it knows how to internally ...
     3  ~ 2014 sep 30ms sql server tuning
     3  +1 2014 sep 22how to read usage indexObtaining Index Usage Information - SQL Server PerformanceIndex usage statistics can be used to determine how useful an index is. Using the information returned from this view it is possible to determine if an index is ...
     3  -1 2014 sep 20speed issues with jewelscart 2000Performance Issue - 2000 Vs 2005 | SQL Server Performance ForumsHi, We are migrating frm 2000 to 2005 and experiencing some performance issues in 2005. Example Query:select...
     3  +6 2014 sep 06performance tuning glossaryGlossary - SQL Server PerformanceGlossary . By Brad McGehee. Allocation Page: A SQL Server page used to ... When referred to in the context of SQL Server performance tuning , it refers to all the ...
     3  +65 2014 sep 01sql server stored proceduresSQL Server Stored Procedures - Fundamentals - SQL Server SQL Server Stored Procedures – Fundamentals. By Tom ONeill. Learning something new is challenging. Learning something new on your own redefines ...
     3  +11 2014 aug 23sql server performance monitor
     4  -3 2014 sep 29sql server slowWhat to do if your SQL Server system is slow | SQL Server What to do if your SQL Server system is slow 0. per Madhu below if you think this is caused by a big query, and want to kill it, follow the steps in ... Performance extremely slow after reboot6 posts10 Mar 2013 Slow response of stored procedure first time called3 posts21 Aug 2012Generally slow databases14 posts24 Oct 2011LAN to WAN = Slow Performance. Why?14 posts3 Aug 2006
     4  +1 2014 sep 17sql server deadlocks per secondTips for Using SQL Server Performance Monitor Counters - SQL Generally speaking, over 1000 batch requests per second indicates a very busy .... track then by using the SQL Server Locks Object: Number of Deadlocks /sec.
     4  +47 2014 aug 13sql server tips
     4  +19 2014 aug 12sql server tuning
     4  +10 2014 jul 28performance tuning sqlserver
     4  +29 2014 jul 28monitor sql server performance
     5  +12 2014 oct 05monitoring sql server
     5  +2 2014 sep 11smo isforegnkeyGenerating Tables Script in one go | SQL Server Performance Forumsfor each object. Uses SMO . ... [FK_CustomerCustomerDemo_Customers]') and OBJECTPROPERTY(id, N' IsForeignKey ') = 1) ALTER TABLE ...
     5  +96 2014 aug 31mssql stored procedureChances are, you are reading my article because you want to learn how to write stored procedures . You are new to this, and you don't know where to start.
     5  ~ 2014 aug 24sql server forumsSQL Server Performance ForumsSQL Server Performance Forums . ... All your SQL Server Questions/Issues for all versions of SQL Server . Discussions: 510; Messages: 1,673. Latest: How to use ...
     5  +85 2014 aug 20stored procedure sql serverWhen you put this SQL statement in a stored procedure , you can then run the stored procedure from the database's command environment (I am a SQL Server  ...
     6  +9 2014 sep 30sql server logHow to Perform SQL Server Log Shipping - SQL Server PerformanceIn a perfect world we wouldn't need standby servers for our SQL Servers . ... This article is about log shipping, a refined variation of the traditional manual standby  ...
     6  +6 2014 sep 21sql server 2008 r2 expressOverview of SQL Server 2008 R2 Express Edition - SQL Server Microsoft released the final version of SQL Server 2008 R2 Express Edition on April 21, 2010. SQL Server 2008 R2 Express Edition continues to ship in 4 ...
     6  +1 2014 sep 16ssis prerequisiteScheduling a SSIS Package with SQL Server Agent - SQL Server Prerequisites for Scheduling SSIS Packages As a prerequisite the SQL Server Agent Service should be running once the package is scheduled to run as a SQL  ...
     6  +95 2014 aug 24sql server replicationSetting up Transactional Replication in SQL Server 2008 R2. - SQL Replication is one of the High Availability features available in SQL Server . Transactional Replication is used when DML or DDL schema changes performed on ...
     6  +95 2014 aug 23replication sql server
     6  -2 2014 aug 09sql server forumAll your SQL Server Questions/Issues for all versions of SQL Server . Discussions: 506 ... Formule sus preguntas sobre SQL Server en Español en este Forum .
     6  +10 2014 aug 03sql hack slowing serverSQL Server Vs Windows Authentication | SQL Server Performance Forumsare made, I think SQL Server is fairly secure (at least not so easy to hack ). ... as far as I know unless you have a really slow domain controller.
     6  -1 2014 aug 01sql server too slowWhat to do if your SQL Server system is slow 0. per Madhu below if you think this is caused by a big query, and want to kill it, follow the steps in ... Performance extremely slow after reboot6 posts10 Mar 2013Generally slow databases14 posts24 Oct 2011Performance is too slow ...9 posts19 Jun 2009database server suddenly running slow 22 posts20 Apr 2005
     6  -1 2014 jul 31performance critical replication monitorPerformance Critical - Merge Replication | SQL Server Performance The replication monitor is showing a warning for Performance Critical on the subscriptions tab. What does this mean, and how can I ...
     6  +10 2014 jul 28ms sql tuning toolImproving 2D Range Query Performance in SQL Server · Refresh the
     6  +24 2014 jul 18sql suspect database repairRecovering a SQL Server Database from Suspect Mode - SQL I then reset the status of the SUSPECT Database by executing the below T- SQL ... Emergency mode repair is the very last resort when all else ...
     7  +20 2014 sep 22configure sql server 2008Before we start with the configuration , we need to understand three important terms: 1. ... Connect to the Microsoft SQL Server 2008 R2 Management Studio. 2.
     7  +7 2014 sep 21ssis prerequisit
     7  +1 2014 aug 09remote link serverDifference between remote login and linked server login | SQL I was troubleshooting an issue with linked server in SQL 2005. I got an error associated with remote logins not defined. So I looked into some ...
     7  ~ 2014 aug 03replication in sql serverIn this article, I will demonstrate the step by step approach to configuring transactional replication in SQL Server 2008 R2. Scenario: An Address table which ...
     7  -2 2014 jul 30select into varchar mssqlCAST(Null As varchar (25)) As CFDCode | SQL Server Performance ForumsCould there be any possibility to cast NULL value in any situation? to ... I couldn't agree more - it's high time they dropped the SELECT INTO  ...
     7  +20 2014 jul 28mssql server tuning toolQure - SQL Server Workload Tuning Tool Review - SQL Server Qure is a workload- tuning tool designed specifically for SQL Server applications. It uses a unique approach to analyse a databases' workload by running its ...
     8  -1 2014 oct 03sql server stored procedure
     8  -3 2014 sep 19sql server disk queueAvg. Disk Queue Length | SQL Server Performance ForumsIs it correct when I monitor the Avg. Disk Queue Length I have to divide the value with
     8  +2 2014 sep 17how to change sql variableAlter Table variable | SQL Server Performance ForumsWhy is it not possible to alter the table Variable ? I used Declare @t table (i int,n varchar(20)) alter table @t add id int identity Error Server:...
     8  -6 2014 sep 13disk queue length sql serverAverage Disk Queue Length | SQL Server Performance ForumsThe system becomes very slow while the Average Disk Queue Length in the db server ( SQL server 2000 standard edition) is maintaining at 
     8  -3 2014 aug 01sql server moveRestore WITH MOVE | SQL Server Performance ForumsUse WITH MOVE to identify a valid location for the file. Server: Msg 3156 ... I have two instances of SQL server on my machine. The QA was ...
     8  -7 2014 jul 31sql server performance slowWhat to do if your SQL Server system is slow 0. per Madhu below if you think this is caused by a big query, and want to kill it, follow the steps in ... Performance extremely slow after reboot6 posts10 Mar 2013Generally slow databases14 posts24 Oct 2011How to Know If TEMPDB is Cause Of Slow ...11 posts13 Sep 2008LAN to WAN = Slow Performance . Why?14 posts3 Aug 2006
     8  -2 2014 jul 23isnumeric sql serverProblem with ISNUMERIC | SQL Server Performance ForumsIch unterstütze PASS Deutschland e.V. e is another instance where isnumeric function fails.
     8  +36 2014 jul 17sql stored procedure exampleI will give you a place to start, teach you techniques beyond the basic “hello world ”, and walk you through examples . I learned how to write stored procedures  ...
     9  +1 2014 oct 05sql server logs
     9  +92 2014 aug 20sql stored procedureHave you ever written SQL statements, like inserts, selects, and updates? Then you have already written most of a stored procedure . A stored procedure is an ...
     9  +92 2014 aug 20stored procedure in sql
     9  +92 2014 aug 17stored procedure example
     9  +19 2014 aug 07select all tableSelecting all tables in a database | SQL Server Performance ForumsHi all What is the query to SELECT ALL THE TABLES from a database? Pl lemme know Sri.
     9  +49 2014 aug 04visual studio database professionalsSchema Comparison with Visual Studio Team Edition for Database It is called Visual Studio 2005 Team Edition for Database Professional (a.k.a. Data Dude). It was released somewhere around December 2006 and not only ...
     9  ~ 2014 aug 03report manager ssl bindingSSRS 2008 host headers and SSL | SQL Server Performance ForumsDoes anyone know how to configure SSRS 2008's Report Manager to ... (Note that the "Add a Report Manager SSL Binding " section doesn't ...
     9  +30 2014 jul 22mail server sql forwardsForwarding Pointers in Heaps - SQL Server PerformanceWhen no clustered index is defined on a table, that table is said to be a Heap. Heaps are not ideal when it comes to performance but there are lots of instances  ...
     9  +92 2014 jul 16sql stored procedures
     10  -2 2014 oct 05sql performance tuningDBA, developer and performance tuning articles and tips on SQL Server, including versions 2008, 2005 and 2000.
     10  +4 2014 oct 03sql server cursorPerformance Tuning SQL Server Cursors - SQL Server PerformanceIf possible, avoid using SQL Server cursors . They generally use a lot of SQL Server resources and reduce the performance and scalability of your applications .
     10  +14 2014 sep 25sqlserver
     10  +13 2014 sep 06ssis file system taskUsing The File System Task in SQL Server 2008 Integration ServicesThe different types of data preparation tasks which are available in SSIS are the File System Task , FTP Task, Web Service Task, XML Task and Data Profiling ...
     10  +2 2014 aug 27sql server log explorerTransaction log explorer | SQL Server Performance ForumsDoes anyone know of any free transaction log explorer to read the logs.
     10  +91 2014 aug 19sql server indexGeneral Tips on Optimizing SQL Server Indexes - SQL Server General Tips on Optimizing SQL Server Indexes . By Brad McGehee. All the tips provided on this website about indexing are general guidelines. As with any ...
     10  +91 2014 aug 13stored procedures in sql
     10  +15 2014 aug 04mirroring replica sql serverDatabase Mirroring VS Database Replication ? | SQL Server We have a special requirement like we have around 21 servers across the globe and ... Database Mirroring or Replication and also reason?
     11  +15 2014 oct 03sql server joinsPhysical Join Operators in SQL Server - Nested Loops - SQL Server SQL Server implements three different physical operators to perform joins . In this article series we will examine how each operators works, its advantages and ...
     11  -4 2014 sep 28sql table unused spaceHeap table unused space and performance | SQL Server Performance We are running into some situations with heap tables in our environment. ... We are still trying to resolve the unused space issues in our other ...
     11  +36 2014 sep 21server store
     11  -1 2014 sep 20sql server clusterAn Introduction to SQL Server Clustering - SQL Server PerformanceAs you may already be aware, there is one way to help boost your SQL Server's uptime, and that is by clustering SQL Servers . This way, should one SQL Server  ...
     11  -7 2014 aug 31sql server lpadLPAD function? | SQL Server Performance ForumsI see in some documentation on the web that there is an " LPAD " function: LPAD ( string, length, pad), RPAD(string, length, pad) Returns string ...
     11  +1 2014 aug 30log explorer sql server
     11  +84 2014 aug 30visual studio team edition
     11  +2 2014 aug 28mssql restore database replicatoonRestore db that set for transactional replication | SQL Server Hi I have setup transactional replication on my production database and it was working fine. My database was corrupted due to some personal ...
     11  +75 2014 aug 27dbf to sqlImport dbase ( dbf ) Files using SQL Server. - SQL Server PerformanceSQL Server integration Service (SSIS) can be used to import data from heterogeneous ... To import several dbf files you should use the Import/Export Wizard. 1.
     11  +90 2014 aug 19sql server monitoring
     11  -4 2014 aug 15msdtc on serverMSDTC on server 'servername' is unavailable. | SQL Server I'm getting the following error message when testing Transaction replication with immediate update " MSDTC on server 'servername' is ...
     11  +7 2014 aug 12alt binaries csvPerfmon output: converting binary to CSV file | SQL Server <img src='/community/emoticons/emotion-1.gif' alt =' :) ' />]<br /><br />Luis ... This will convert binary to csv no problem. I have tried it and it works ...
     11  +4 2014 aug 07reparing suspect databseI then reset the status of the SUSPECT Database by executing the below T-SQL ... Emergency mode repair is the very last resort when all else ...
     11  +11 2014 jul 23sgl index tuning traceSQL Server Index Tuning Wizard Tips - SQL Server PerformanceUse the SQL Server Index Wizard and an appropriate Profiler trace file to help ... When creating the Profiler trace that is used to base the Index Tuning Wizard ...
     12  +16 2014 oct 01sql server monitor
     12  +89 2014 sep 28sql server 2005How to Cluster SQL Server 2005 - SQL Server PerformanceBelieve it or not, the procedure to install a SQL Server 2005 instance onto a cluster is one of the easiest parts of getting your SQL Server 2005 cluster up and  ...
     12  +23 2014 sep 27triggers in sql serverImplementing Triggers in SQL Server 2000 - SQL Server PerformanceThere are two different types of triggers in Microsoft SQL Server 2000. They are INSTEAD OF triggers and AFTER triggers . These triggers differ from each other ...
     12  +50 2014 sep 25sql server join
     12  +33 2014 sep 14sqlserver triggerTriggers are special types of Stored Procedures that are defined to execute automatically in place of or after data modifications. They can be executed ...
     12  -5 2014 sep 08litespeed backupHow to differentiate between a litespeed backup and native SQL We used native SQL backups for DB backups . Recently, one of the DBA installed Quest Litespeed on the Server and told he changed some of ... LiteSpeed backup status2 postsAug 22, 2009 LiteSpeed Backup and restore using filegoups17 postsOct 19, 2006 LiteSpeed performance notes5 postsOct 14, 2006
     12  +61 2014 aug 27trigger sql server
     12  -4 2014 aug 13how to restart sqlserverSafe way to restart SQL Server services? | SQL Server Performance You can restart the SQL Server Services as shown in the below links. use these scripts in a Job and schedule it. It will solve your " restarting " ...
     12  +38 2014 aug 13sql server query optimizerUnderstanding SQL Server Query Optimization - Part 1 - SQL Server In the first of this four part series I will give an overview of the tools and techniques of query optimization in SQL Server . Most of the activity of the database server ...
     12  +20 2014 jul 24mssql int to charINT vs CHAR | SQL Server Performance ForumsHi all -- I am using MS SQL 2000 and cannot use the BIT data type because the ... IN any case use of INT is better than using CHAR in terms of ...
     13  +1 2014 oct 03sql server clustered indexTips on Optimizing SQL Server Clustered Indexes - SQL Server As a rule of thumb, every table should have a clustered index . Generally, but not always, the clustered index should be on a column that monotonically ...
     13  -2 2014 sep 21lun disk queue sql serverThe system becomes very slow while the Average Disk Queue Length ... you are running on a SAN, what with the way LUNs are configured etc.
     13  -3 2014 aug 29lumigent log explorerDoes anyone know of any free transaction log explorer to read the logs . ... by Lumigent Technologies is the best tool to explore transaction logs .
     13  +88 2014 aug 17triggers sql server
     13  -4 2014 aug 14database mail attachmentLarge attachments in database mail | SQL Server Performance ForumsHI , Everyone Please help me in dbmail while i sending a large attachment . it gives an error like this. "The mail could not be sent to the ...
     13  -1 2014 aug 06select with nolockSelect statement with ( NOLock ) | SQL Server Performance ForumsRefer to below SQL script Select Field1, Field2, ( Select Field99 from Table3 with ( NoLock ) Where .... ) Field3 from Table1 with ( NOLock ) Inner ...
     13  -3 2014 aug 03script shring log fileHow to truncate log in SQL Server 2008? | SQL Server Performance We can not issue backup log command in simple recovery model. ... he/she should not shrink the database file (s) as it would cost time and I/O ...
    1 2 of 12 pages