Viewing 15 posts - 286 through 300 (of 360 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...
Quand on parle du loup, on en voit la queue
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
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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
Quand on parle du loup, on en voit la queue
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
Quand on parle du loup, on en voit la queue
May 13, 2003 at 12:38 pm
Where in Houston? East, West, Downtown?
Thanks,
Patrick
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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....
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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....
Quand on parle du loup, on en voit la queue
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...
Quand on parle du loup, on en voit la queue
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
Quand on parle du loup, on en voit la queue
April 30, 2003 at 6:47 am
Viewing 15 posts - 286 through 300 (of 360 total)