Viewing 15 posts - 91 through 105 (of 992 total)
Cross posted - replies to http://www.sqlservercentral.com/Forums/Topic458952-19-1.aspx.
February 22, 2008 at 1:59 am
It's a real shame that you're forced into the single DB model as you lose so many benefits, as others have espoused, such as
* being able to take individual...
February 21, 2008 at 4:56 am
You didn't post what you subsequently tried after the previous (correct) suggestion. I admit that I had no idea what you were on about but the previous suggestion, turned...
February 21, 2008 at 4:46 am
Manual processes such as moving rows around should be considered after things such as
1. Indexing - are you indexing on the correct columns?
2. Partitioning - If you have REALLY...
February 21, 2008 at 4:42 am
It's not like you're going to be running webcams, video cards, games or odd scanners on your server, so go 64 bit 🙂
When you use mirroring just keep in mind...
February 21, 2008 at 4:39 am
Good tip 🙂 I must admit that I'll still probably stick with letting the GUI tools do all the ugly scripting for me as most of our customers don't...
February 21, 2008 at 4:24 am
Could you please post some of the relevant code?
How many rows are you talking about?
February 21, 2008 at 4:23 am
And I would get your reporting tool to do the cross-tab rather than trying to bend a SQL resultset to do it. For example, both Crystal Reports and SQL...
February 17, 2008 at 8:03 am
You could create SupplierContact and WholesalerContact tables and use one of these at a time to relate a contact to a supplier or to a wholesaler. To have MS...
February 17, 2008 at 1:23 am
Whilst changing the SET options will fix your issue for the time being, you really should always have the ANSI options set because they're required for things such as indexed...
February 16, 2008 at 8:51 pm
Especially since a transfer data task may not insert the data into the tables in a way that doesn't violate any referential integrity constraints (you DO have them don't...
February 16, 2008 at 8:49 pm
Often we have problems with American date formats vs ISO formats vs rest of world formats 🙂 (we in Australia use dd/mm/yyyy). Check which format you're using. ...
February 16, 2008 at 8:47 pm
Actually, I surprised myself and bothered to do it 🙂
Try this - same as before in tempdb with two query windows...
Window #1
create table test_table(
id int identity(1,1) primary key...
February 16, 2008 at 8:43 pm
I believe that to guarantee it you might need a table lock. Your code implies that the 5 records are inserted in a single statement... I've got a...
February 16, 2008 at 8:33 pm
Viewing 15 posts - 91 through 105 (of 992 total)