RE: Daylight Savings time change effect on jobs
There's another thread about this in the Backups forum: http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=142470#bm142884Greg
2004-10-27
Indexing
RE: Manipulating And Using DateTime Data
One of the habits that I have developed, especially while developing date driven reports is to add this code to every stored procedure that I create: --Include the entire End Date (Set time to 11:59) Select @EndDate = DateAdd(d, 1,@EndDate) Select @Enddate = cast(convert(varchar, @EndDate,101) as datetime) Select @EndDate = DateAdd(s,-1,@EndDate) --This is usually done […]
2004-10-27
RE: Database Migration Methodology Questions
Here's the MS KB for more info if you need it.http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546
2004-10-24
RE: Question of the Day for 19 Oct 2004
I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.
2004-10-22
10 Ways to Optimize SQL Server Full-text Indexing
Indexing performance has always been the Achilles' heel of SQL Server's full-text feature. Although the search performance itself is fast (very few customers complain about the search speed), users do complain (often loudly and frequently) about how slow the indexing process is–especially for large tables. Here's a few tips for you.
2004-10-15
2,630 reads
RE: Exporting to Excel Script
The code you posted is the same piece of code that I am trying to get work with only one modification. You removed the credits!/* Version: SQL Server 7.0/2000 Created by: Alexander Chigrik http://www.MSSQLCity.com/ - all about MS SQL (SQL Server Articles, FAQ, Scripts, Tips and Test Exams).This stored procedure can be used to insert the […]
2004-10-14
RE: Question of the Day for 14 Oct 2004
Well, Kelvin, you sure know how to kill a lively debate stone dead. You are correct of course.
2004-10-14
Drop all foreign keys
Drops all the foreign keys in a database. This is useful when rebuilding data warehouses.
2004-11-30 (first published: 2004-10-13)
1,425 reads
RE: Auto-incrementing within a PK
Hi yaip, I discovered a minor flaw in the previous code when new records contain sequence numbers that are greater than the existsing numbers (if a gap in the DisplaySeq values is considered a gap). The following code fixes this: create table test_tab (RoleID int ,MenuID int ,DisplaySeq int ,primary key (RoleID, MenuID) ) go […]
2004-10-11
Using fully qualified names
Hello Everyone,I am trying to find out if it is necessary to use fully qualified names for adhoc sql statements to improve performance. Say for example I am running the query below on Query Analyzer on database dbname. Would it be necessary for me to use SELECT * FROM dbname.dbo.tableOr will it be the same as […]
2004-10-04
73 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers