Viewing 15 posts - 35,716 through 35,730 (of 39,771 total)
We'll get some pages, or maybe the whole thing up here soon.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 18, 2003 at 3:31 pm
I'm a little confused as to what you mean. Do you need to strip out the numerical value (8) from the input? Or do you need to figure out how...
November 18, 2003 at 1:31 pm
Where do you see 16%? The CPU column should be ms used.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 18, 2003 at 11:16 am
I think this may be related to your SAN not respecting the semaphores. Can you hole two open files from WORD or notepad or somthing on htis drive?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best...
November 11, 2003 at 3:31 pm
It doesn't modify schema as far as I know. There are some security changes, but I think there are some security fixes that may impact your environment.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
November 11, 2003 at 3:29 pm
I'd use the dot notation. I think that this is more likely to be supported, but that's an opinion. I don't know if it's really true.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
November 11, 2003 at 3:27 pm
sp_password null, <new>, sa by any administrator
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:25 pm
check our script library, there are a few different ones there.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:21 pm
The SQL Server db would be the warehouse. The movement of the ASCII file would be the ETL (extraction, transformation, and loading) phases.
A warehouse can be used for querying, bilding...
November 11, 2003 at 3:20 pm
don't think there is a way.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:17 pm
I'd create a clustered index. I hear over and over that the query optimizer likes this. Even if it isn't meaningful, I think having one helps.
That being said, create and...
November 11, 2003 at 3:15 pm
What is right before and after this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:12 pm
Honestly, I haven't found a good way to do this. I suspect some type of UML tool like rational would work well, but they are so expensive and you have...
November 11, 2003 at 3:11 pm
I'm sure there's a way, but offhand I can't remember what it is.
this might help a little:http://www.sqlfe.com/default.asp (haven't used it)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:09 pm
the only way you could check across all servers would be if you have linked servers connecting them.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
November 11, 2003 at 3:02 pm
Viewing 15 posts - 35,716 through 35,730 (of 39,771 total)