Viewing 15 posts - 286 through 300 (of 359 total)
Hmmm - I was taught to use varchar when I assumed a variation in the size of the data.
Whenever possible define the column as char. It's not that big...
May 16, 2003 at 9:20 am
It can be done. I trimmed off the 'FRI' part and it converted. I used a substring.
Patrick
May 15, 2003 at 3:16 pm
Follow the execution plan for your queries and check to see if they are using indexes or table scans. This can also give you a clear idea if you have...
May 15, 2003 at 7:26 am
We installed a new instance of SQL2K. No one could connect to it. I checked and the client utilities all listed TCP/IP over named pipes. I changed the order so...
May 14, 2003 at 11:38 am
I've worked with Access, MySQL (for those cash-strapped web companies) and just a little of Postgres. I was impressed with Postgres.
Patrick
May 14, 2003 at 10:01 am
You should always use column IS NULL rather than column = NULL. Nulls do not equal each other (or itself).
Patrick
May 13, 2003 at 12:38 pm
Where in Houston? East, West, Downtown?
Thanks,
Patrick
May 12, 2003 at 9:13 am
Cursors are fine. They are a tool, that's all.
It's as if you are claiming you never use the tack hammer. That's fine. There are times that a tack hammer...
May 9, 2003 at 12:15 pm
No magic deletes.
I have used the sp_msforeachtable and that works. But I also have created a cursor to do the deletes when the column names are not the same....
May 9, 2003 at 12:08 pm
On the databases I have AutoClose off. It's one of those really bright ideas that no one wants.
Autoshrink is off because I found it twice trying to shrink itself...
May 7, 2003 at 11:37 am
Check out the section "Maximum Capacity Specifications" in BOL. That has limitations and capacities for all version of SQL Server 2000.
Patrick
May 7, 2003 at 11:31 am
SQL Server uses a sampling of the data to determine if the stats are outdated.
Index hints should be avoided, but there are times when they are very useful. I...
May 5, 2003 at 11:43 am
Laughing. As a DBA I'm shy about auto-anything. On your job that repopulates the table add a task to reindex or sp_updatestats.
Yes, autoupdate works on a sampling of the table....
April 30, 2003 at 11:32 am
Brian,
Good article.
Yes. When I decide to go for a test, I schedule it. Nothing like having the cash already spent to give me incentive.
Tests for similar subjects I...
April 30, 2003 at 7:33 am
Truncate Table deallocates the table's data pages and index pages. The deletion of rows can not be logged, because they are not really deleted. The page deallocations are logged.
Patrick
April 30, 2003 at 6:47 am
Viewing 15 posts - 286 through 300 (of 359 total)