Viewing 15 posts - 50,086 through 50,100 (of 59,078 total)
bobjbain (6/12/2008)
must be talking to myself on this thread!!
Would you rather have someone say something like... "I've never had such a requirement, never heard of such a problem, and therefor,...
June 12, 2008 at 8:32 am
I agree mostly... the second one... just loose the square brackets for readability purposes and don't use aliases that require them with the rare exception being reporting queries.
June 12, 2008 at 8:23 am
I'm thinking that your connection string had better be connecting you to some database other than the one you're detaching.
June 12, 2008 at 8:20 am
These are some fairly broad questions that would probably be best answered by looking up things like "working with cubes in SQL Server" or "using olap" or somesuch in Books...
June 12, 2008 at 8:14 am
Might have to setup something like a web service to run on an intra net... lot's of folks do such a thing... Talk to anyone who writes ASP.Net or...
June 12, 2008 at 8:04 am
There are very few reasons why this may happen...
--Uncommitted transaction
Do a transaction count at the end of the proc to find out. Might take a bit to find if...
June 12, 2008 at 8:00 am
SQL Server 2005 allows you to write PIVOT queries. Lookup the keyword PIVOT in Books Online. Books Online comes free with SQL Server and is the "help" system...
June 12, 2008 at 7:34 am
Not likely the database did it... either a human or some other program did it. Finding out what changed it will take some doing, though.
Should never grow by percent,...
June 12, 2008 at 7:32 am
One of the cylinders on my car is misfiring... I can't understand why the mechanic blew me off when I told him he couldn't look under the hood because I...
June 12, 2008 at 7:29 am
I'd say that's a pretty tall order unless you have a particular domain in mind that want's particular formatting rules. Then, you could use LIKE to build a...
June 12, 2008 at 7:23 am
Here's a "cheater" method...
count(*)*1.0/(DATEDIFF(s, MIN(scan_datetime), MAX(scan_datetime))) as ItemsPerSecond
June 12, 2008 at 7:12 am
Ok... now that everyone has figured stuff out... how 'bout everyone post their solutions? 😉
June 12, 2008 at 7:07 am
I found it... them, really.
http://www.sqlmag.com/Articles/ArticleID/19851/19851/pg/2/2.html?Ad=1
http://www.sqlmag.com/Article/ArticleID/20242/sql_server_20242.html
I'm not a "member" of that particular site so I can't see the whole article. What I glean from the two articles is...
June 12, 2008 at 6:54 am
AndyD (6/12/2008)
Jeff Moden (6/12/2008)
I remember seeing an article on the difference between 0% and 100% fill factors... Dunno if I can find it, again, but I'll look...
I was only regurgitating...
June 12, 2008 at 6:43 am
AndyD (6/12/2008)
Just one quick question - you mention the Fill Factor defaults to 100% in 2005, whereas it was 90% in 2000. [To be precise,...
June 12, 2008 at 6:26 am
Viewing 15 posts - 50,086 through 50,100 (of 59,078 total)