Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, SQL Server 7 Rss

<< Newer    Items 41 to 60 of 138    Older >>
 

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,765 reads

Stored Procedure vs Triggers

Performance tuning is an ongoing battle in SQL Server, but having a little knowledge up front when designing an application can greatly reduce the efforts. Do you know which performs better: stored procedures or triggers? There aren't many places where the two are interchangeable, but knowing the impacts of each might change the way you build an application. Read about this analysis by Vijaya Kumar.   Read more...
By Gulappa Vijaya Kumar 2006/03/31 (first published: 2004/08/30) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 38,987 reads

Stop SQL Injection Attacks Before They Stop You

A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.  Read more...
By Additional Articles 2004/08/20 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 2,409 reads

Beginning SQL Server - Limit Your Queries

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.   Read more...
By Steve Jones 2006/04/14 (first published: 2004/08/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,910 reads

Seven Showplan Red Flags

SQL Server showplan is a great tool for analyzing queries and determining whether or not more performance tuning needs to be done. However working with showplan can be confusing and it takes some practice to learn the ins and outs of what is occurring. Joseph Sack looks at showplan and seven of the main things that he is aware of when looking at the results. If you've rarely or never used showplan, this is a great article to get started in learning how an experienced DBA views the output.   Read more...
By Joseph Sack 2004/07/15 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 20,375 reads

Case Sensitivity in Selects - Part 2

In this follow up Andy looks into some of the options available when you're dealing with situations where you're joining a case sensitive column to a case insensitive column. We think after reading this you'll be ready to just say no!   Read more...
By Andy Warren 2004/06/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 8,320 reads

Case Sensitivity in Selects - Part 3

See what a reader had to say about Part 1, make sure you've read Part 2, then feel the pain as the author describes a lookup table that should have had unique values and doesn't.   Read more...
By Andy Warren 2004/06/15 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,338 reads

Making Good Use of Sysforeignkeys Table - Part 1: Display table relati

Sysforeignkeys is a valuable SQL Server resource. How many times have you had to "pick up the pieces" from a database developed by someone else and dropped on your desk? Ever get a database diagram with that? A data dictionary? Probably not too often. Jeffrey Yao has developed a system of finding those parent-child relationships automatically and displaying them so he can get up to speed quickly on these inherited databases. Read on to find out more.   Read more...
By Jeffrey Yao 2004/06/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,607 reads

Creating a System Stored Procedure

Creating a system stored procedure isn't hard. You're always cautioned from making changes to the system, depending on the system for a particular functionality, etc., and you should be cautious. However adding system stored procedures to your servers can be beneficial and make your administration much more convenient. Read on the see how easy this can be to do.   Read more...
By Robert Marda 2004/05/20 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,247 reads

Overview of Performance

How can you tell if your code if performing well? Do you know what you want to look for when starting to analyze code? Here's an article from Leo Peysakhovich that looks at some of the things that you can use at a high level to improve the performance of your code.   Read more...
By Leo Peysakhovich 2004/05/11 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 12,422 reads

Execution Plans

How many of you use Execution Plans to tune your queries? Do you understand the impact of different indexes? Mr. Vijayakumar looks at his experiments with different types of indexes and their effects on the execution plan use. A great article for those of you that want to learn more about how you can tune your server for better performance.   Read more...
By Gulappa Vijaya Kumar 2005/10/07 (first published: 2004/05/06) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 51,596 reads

Tracing Deadlocks

New Author! Deadlocks aren't the most common problem but they happen they can really degrade performance. Shiv works through how to nail down what is causing the deadlock.   Read more...
By Shiv Kumar 2007/04/06 (first published: 2004/04/06) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 43,521 reads

Measuring SQL Performance

One thing that often amazes me is that many SQL Server developers do not actually measure the performance of their queries. Many of them thought that you needed external tools, more or less complicated, to run against your server, and they did not have the time or inclination to learn and try these. This article will describe a couple of much easier methods of measuring performance of queries.   Read more...
By Christoffer Hedgate 2005/12/23 (first published: 2004/04/02) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 33,384 reads

How to Make Sure You Have Good Passwords

As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.   Read more...
By Robin Back 2004/03/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 6,626 reads

SQL Injection!

Do your developers really understand how to prevent injection attacks? Or scarier still, how many know what an injection attack is? Chris has some great examples of how sql injection works and how to prevent it.   Read more...
By Christoffer Hedgate 2004/02/02 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 16,713 reads

Debugging MSDTC Issues

For the most part the DTC (Distributed Transaction Coordinator) just works. What happens when it doesn't? Chris had to resolve an issue with it recently and documented some of the steps he used.   Read more...
By Chris Kempster 2004/01/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,485 reads

Alert! Alert! Backup and Restore Baby!

Are you using alerts to help you keep track of things? Are you using as many alerts as you should be? Jeremy has a great list of alerts that he considers so important they are on his 'best practice' list. Definitely worth reading.   Read more...
By Jeremy Kadlec 2004/01/08 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,870 reads

Using xp_cmdshell

Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.   Read more...
By Haidong Ji 2004/01/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,720 reads

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,422 reads

Scaling Out

Kumar discusses the differences between scale up and scale out, then does a very good walk through of how to build a scale out solution.   Read more...
By Kumar Part 2003/12/03 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 7,267 reads
<< Newer    Items 41 to 60 of 138    Older >>
 
Tags
administration (56)    
miscellaneous (44)    
performance tuning (38)    
advanced querying (25)    
programming (18)    
configuring (16)    
stored procedures (16)    
security (13)    
strategies (13)    
monitoring (12)    
visual basic 6 (8)    
database design (7)    
backup / restore (6)    
indexing (6)    
sql server 2005 (6)    
counter (4)    
development (4)    
dts (4)    
installation (4)    
nums (4)    
sql-dmo (4)    
sqlinsider scripts (4)    
table of numbers (4)    
tally (4)    
triggers (4)    
user defined function (udf) (4)    
.net (3)    
arrays (3)    
basics (3)    
delimited strings (3)    
naming standards (3)    
parse (3)    
sql server 6.5 (3)    
string manipulation (3)    
xml (3)    
ado (2)    
auto-growth (2)    
automated dba (2)    
best and worst practices (2)    
data file management (2)    
maintenance (2)    
maintenance and management (2)    
openxml (2)    
replication (2)    
routine database growth (2)    
routine growth (2)    
storage (2)    
updategrams (2)    
utility (2)    
worst practices (2)    
xsl (2)    
alias data types (1)    
databases (1)    
date manipulation (1)    
distributed queries (1)    
english query (1)    
grant (1)    
logins (1)    
news (1)    
permissions (1)    
product reviews (1)    
restore (1)    
reviews (1)    
role (1)    
schemas/dtds (1)    
script (1)    
scripting (1)    
service packs (1)    
sql puzzles (1)    
system development life cycle (1)    
table (1)    
user (1)