More questions than answers for starters:10k or 15 K disks ? what size ? smart array disk controllers or the builtin ? if smart array controllers, how much memory ? what is the database size (data/log) ? how many users ?
2005-03-11
I have never done this via DMO however, just from looking at the information provided I don't think that DMO is smart enough to realize that "I" am (local)....
2005-03-10
I stated that I can use SQL Mail fine. I don't use xp_sendmail - I just stated that I can. I don't understand why I cannot use the SQL Agent mail. I want to be able to create an Operator that can be emailed when something goes wrong. I cannot do that unless SQL Agent […]
2005-03-10
sorry to be a newbie, but what do you mean "do you have an UPDATE trigger on the table?"..
2005-03-09
I created and viewed the .sql file. The instruction to delete the logs is in there. What I have discovered though was that the job has been reported as having failed. This would account for the fact that the files were not deleted.What is puzzling though is that the SQL log itself indicates the log files […]
2005-03-09
assuming both fields are numbers Select CAST(IDNUMBER as varchar(15)) + CAST(PRINTCOUNT as varchar(10)) as ConcatenatedField from dbo.MyTable
2005-03-09
"... am I just barking up the wrong tree doing this?"Ahhh ... in word ... yes.Wouldn't having the "code more organized" remove most of your naming conflicts? I would think the downside of having everything in one database is a lot smaller when you consider the additional maintenance and performance requirements for all those triggers.
2005-03-03
If I repeat the same derived table 2 or 3 times in my SQL select statement, the execution plan looks like it executes the same select code several times. Do CTEs make the execution plan more efficient in such cases or is it merely a (very) nice shorthand?
2005-03-03
You might want to check out this page to verify that you are actually using Unicode http://mysecretbase.com/ColdFusion_and_Unicode.cfmAlso, storing a resume in a nvarchar column might be a tight fit. You can try ntext for more space.You also might want to research collations in the SQL Server manual. It may provide you with some key insight.Good luck.
2005-03-03
i would lean toward DNS issues thenping servername -ait should say "Pinging servername.domainname.com......."if DNS resoultion is working correctly.
2005-03-03
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers