Viewing 15 posts - 29,941 through 29,955 (of 39,818 total)
January 13, 2008 at 8:28 pm
Mark,
Thanks and I understand the reasons, but it's still something that I never have come across in the SQL Server documentation. I wanted to point it out to be sure...
January 13, 2008 at 8:26 pm
I'd probably use some type of replication to move data around, but I'm more comfortable with that. If you're comfortable with Perl or DTS, use that.
You need to track down...
January 13, 2008 at 8:25 pm
If you have DB1, DB2, DB3, I'd recommend you create a view for each table.
In DB1, create view db2Employee as select * from db2.dbo.Employee.
Also, create view db3Employee as select *...
January 13, 2008 at 8:22 pm
The bigger issue I think is that you haven't provided any abstraction layer for performance tuning and you're not taking advantage of the power of SQL Server. Stored procedures can...
January 13, 2008 at 8:19 pm
Usually a group by has an aggregate in it (SUM, COUNT,etc). Otherwise you're not really grouping by anything.
January 13, 2008 at 8:16 pm
No hammers or nails needed. Just $20-25 for tokens at the batting cage. Get a nice 34-incher.
January 13, 2008 at 10:33 am
OK a few grammar items so I'm sure we're communicating.
You have a database "ON" a system. It can be set up to automatically take a backup "TO" itself, meaning copy...
January 13, 2008 at 8:18 am
It is possible the stats are out of date for the insert, but that won't matter. They aren't used for an insert. They're used on the next SELECT. Running stats...
January 13, 2008 at 8:15 am
You are running from the "Binn" directory? Other commands work, like "dir"
What about just running "sqlservr"
January 13, 2008 at 8:13 am
I haven't seen much in my list of blogs (50-60) that I check. There are some good entries with Craig Freedman, but seems to be 2005.
I don't think there are...
January 12, 2008 at 9:57 pm
I'd look to split these out. You can build a bigger box, but if you have issues, especially runaway queries, then it affects a lot of clients. Better to limit...
January 12, 2008 at 9:54 pm
I hear great things about the Apex Editor and SQLPrompt from Red Gate.
If you have a nice budget, Erbarkadero has a nice modeling tool if you have a use for...
January 12, 2008 at 9:53 pm
I'd run Profiler, grab the most often run queries, and start dissecting what they mean and how the data relates. Most often run queries mean you'll deal with that data...
January 12, 2008 at 9:50 pm
Viewing 15 posts - 29,941 through 29,955 (of 39,818 total)