Viewing 15 posts - 21,991 through 22,005 (of 22,194 total)
What you usually see in the STATISTICS is the time on the server. It doesn't include time to move the data to your machine or time to display the graphics....
January 26, 2007 at 5:38 am
Several people have commented that they use NOLOCk or setting the isolation level because they're in a read only environment. Have any of them considered setting their database to read...
January 25, 2007 at 5:37 am
Just an idea. Buy vs. Build always has trade-offs in either direction.
There are other text indexing products out there. Shop around.
January 23, 2007 at 12:37 pm
Is there an INNER JOIN involved to arrive at the data being selected. Join criteria is evaluated prior to the WHERE clause and you can sometimes move things from the...
January 23, 2007 at 6:56 am
If you're going for cheap, then you just need to set up full text indexing that comes with SQL Server 2005. Otherwise, I found this information on the Google site:
January 22, 2007 at 6:28 am
Are you kidding? Set logic is bloody difficult. I have a hard time wrapping my brain around it almost daily. I just know that I have to take the approach...
January 19, 2007 at 10:20 am
Just to start with, no:
SELECT * FROM ... LIKE 'Asp.net%'
will only find data that is starts with Asp.net. If you want to search in the middle of a string you...
January 19, 2007 at 8:32 am
It's not so much the database that's set oriented, although that's a big part of the issue. It's that TSQL is set oriented. Especially 2005 with common table expressions &...
January 19, 2007 at 8:28 am
I agree with Ms. Shaw. Who wouldn't. You may also want to consider using a unique constraint:
ALTER TABLE [x]
ADD CONSTRAINT [y]
UNIQUE NONCLUSTERED ([emailaddress],[password]) ON [PRIMARY]
Then you get the index suggested...
January 19, 2007 at 7:09 am
Now that's sweet. I had not known of this one prior to today. Thanks for posting it.
January 19, 2007 at 5:33 am
Nice choice. Beats a cursor in most situations.
January 18, 2007 at 11:32 am
Crud I hate that. My first response went into the ether and my second got posted so I look like a schmuck. Sorry about that. What I said was:
Generating objects...
January 18, 2007 at 5:17 am
Oops, should have added, SMO means SQL Management Objects. It's in the BOL, including decent (if not good) references & samples.
January 18, 2007 at 5:11 am
Based on what you're suggesting, you might want to look at doing a little SMO programming. You can quite simply generate a CREATE script for various objects from there.
January 18, 2007 at 4:32 am
Viewing 15 posts - 21,991 through 22,005 (of 22,194 total)