Viewing 8 posts - 1 through 8 (of 8 total)
Or why not use the CHARINDEX function instead of IN, this would avoid creating a temp table and avoid doing any parsing:
WHERE CHARINDEX("'" + CARRIER +...
October 8, 2003 at 1:00 am
I agree with you iastrebov! I chose the 8GB option as I understood the question as to mean "Which is the smallest amount of memory to be installed at...
September 16, 2003 at 12:53 am
I also agree with you. The question stated that the user was a developer and I'd assume this means not a DBA - I think the question was a...
September 4, 2003 at 1:56 am
I had a similar problem myself where the agent was shown as starting and wouldn't shutdown. Fortunately a reboot solved it.
I still don't know what caused it but sounds...
July 9, 2003 at 1:17 am
The following link discusses the problem:
I believe it is a known problem in sqlmaint.exe which effects databases with computed columns??
Does anyone know of an MS tracking number for...
May 19, 2003 at 11:51 am
I'm also having this problem. (See my slightly earlier post "Maintenance plan/DBCC problem").
It might be worth having a look at a MS knowledgebase article:
Although this hasn't helped...
May 19, 2003 at 11:40 am
Does anyone have any thoughts on what rights should be taken away from the public role in master?
January 8, 2003 at 1:19 am
It was mentioned above that specifying the workstation id in the connection string could affect connection pooling due to non-identical connection strings.
Please correct me if I'm wrong but the way...
September 26, 2002 at 1:25 am