Viewing 15 posts - 2,431 through 2,445 (of 7,429 total)
Not sure I understand what you are after. Are you talking about record display to the end user within an application? If so then DTS isn't a good choice, it...
November 7, 2003 at 4:57 am
quote:
quote:
In the US the numbers are 10 digits (at least for the foreseeable future)...
November 7, 2003 at 4:49 am
It only stores the trace info (T-SQL Statements, Errors and bits of other info). 100 quiries on either 7 or 2000 would be under 5MB. With 7 thou only the...
November 7, 2003 at 4:42 am
Duplicate post please see / post in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17916&FORUM_ID=8&CAT_ID=1&Topic_Title=Select+count%28%2A%29+returns+a+null+value&Forum_Title=T%2DSQL
November 5, 2003 at 7:53 am
Duplicate post please see / post in http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17916&FORUM_ID=8&CAT_ID=1&Topic_Title=Select+count%28%2A%29+returns+a+null+value&Forum_Title=T%2DSQL
November 5, 2003 at 7:53 am
Keep in mind if testing in QA it has it's own connection parameters Tools-Options->Connection Properties which override all settings in SQL Server when attaching. Check there and make sure is...
November 5, 2003 at 7:51 am
In the US the numbers are 10 digits (at least for the foreseeable future) so it makes things a bit easier. In this case I would either use bigint to...
November 5, 2003 at 7:48 am
quote:
How many memory does SQL 2k ENT(64bit) can support with Win2003 ENT(32 bit)?
0 as noted...
November 5, 2003 at 5:09 am
You do need to run against each instance since there are sql statements ran against the master and other things. As for recovery you will have to install each instance...
November 5, 2003 at 4:46 am
What is the tempDB size, how mauch drive space is left, what is the ram and page file amounts, have you checked for unneccessary services running, and have you recently...
November 3, 2003 at 5:05 am
quote:
http://www.devx.com/tips/Tip/17668
Unfortunately as US times are now different the sample you provide will come up wrong....
November 3, 2003 at 4:41 am
I think users should have the option of client or service type to use. However incoming needs to have virus scanning intgrated so any product can perform. Maybe a block...
November 3, 2003 at 4:26 am
You are absolutely right about the difference from country to country and in many cases they even just declare it as needs be (I had a site about the rules...
October 30, 2003 at 10:25 am
These are the bits I use in either sp or udf, I did have a calculate bit I built but cannot find right now. I had been working on a...
October 30, 2003 at 8:26 am
quote:
quote:
Of course it's the Cambridge University Netball Team that I really feel sorry for...
October 29, 2003 at 5:14 am
Viewing 15 posts - 2,431 through 2,445 (of 7,429 total)