This article, Part 2 – SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture, will begin to detail the technical components faced by the DBAs and Developers during the Upgrade process. The technical components detail the Critical Upgrade Decisions related to ANSI NULLS, Quoted Identifiers and other items.
2003-06-30
2,377 reads
This article discusses various SQL Server Data Transformation Services (DTS) best practices. It is divided into sections like DTS naming conventions, DTS documentation, troubleshooting DTS packages, improving the performance of DTS packages, securing DTS packages, DTS resources.
2003-06-24
4,068 reads
In addition, if you want to get rid of case statements you could use SELECT @where_clause = @where_clause + ISNULL(@return+' AND Case_no# = '''+@param1+'''','')+ ISNULL(@return+' AND last_name = '''+@param2+'''','')+ ISNULL(@return+' AND [First name] = '''+@param3+'''','')+ ISNULL(@return+' AND Determination = '''+@param4+'''','')+ ISNULL(@return+' AND sender = '''+@param5+'''','')+ ISNULL(@return+' AND [Case Type] = '''+@param6+'''','')+ ISNULL(@return+' AND Date = […]
2003-06-20
Another way to handle this is with a simple case statement in the WHERE clause. We use this alot as most of our sp's run with multiple, non-required paramenters. We have procs with 15-20 parms and it works fine. Example proc: create test_proc @parm1 int=0, @parm2 varchar(10)=null, @parm3 varchar(20)=null as select field1, field2, field99 from […]
2003-06-18
1 reads
2003-06-17
Wouldn't you just redclare the column without IDENTITY in the definition?: ALTER TABLE MyTable ALTER COLUMN MyIdentityColumn INT NOT NULL
2003-06-17
1 reads
It depends. Cursors are notroious for being used where not actually needed, but generally this is because the better solution is not seen. Look at you code and consider what it does and see if you can think of what might do the same thing without a cursor (even if it mens using temp tables). […]
2003-06-16
1 reads
Join SQLServerCentral.com co-founder Brian Knight for this free webcast on SQL Server security best practices. In this session on Technet, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.
2003-04-02
1,994 reads
Not even worth talking about, right? Probably, but they still exist. Read about this worst practice and pass it along.
2003-03-31
5,364 reads
Join SQLServerCentral.com co-founder for this free webcast on SQL Server security best practices. In this session, we will look at how to protect your system from internal and external security factors. We will look at the types of permissions in your database objects, implementing column and row-level security, and protecting yourself from SQL Injection attacks. We'll also cover best practices for basic and advanced protection for your SQL Server system.
2003-03-27
364 reads
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers