Forum Replies Created
Viewing 15 posts - 35,881 through 35,895 (of 39,720 total)
-
RE: mccork has hit 500 post
Congrats, personally answering questions is a nice break from work, much better than cigarettes
.Plus I learn a few things from watching randome threads.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
-
RE: Join of System Tables
I think Andy Warren has some hard copies. Send him an email and he might be able to get you one (awarren@sqlservercentral.com)
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
-
RE: General RDBMS Problem
research, ask specific questions, learn from others.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: stored procedure problem
charindex is my vote. IN doesn't work with string variables.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Hot keys
Tools | Customize
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Revisions.. Incrementing letter revisions..
Good idea, please post it.
I'd prbably attack it by getting the ASCII code and incrementing that, rolling over on Z, but that's me.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
-
RE: More NULLs - need help BAD !
OR
If exists( select * from table where val is null)
select 'null'
else
select sum()....
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Enterprise Manager
Not in Enterprise Manager. You can for the login and if they use QA and the Object Browser, they should get better performance.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
-
RE: SQL strange problem. Please help!
Good suggestions above. If it's been working and suddenly doen't, either you have a data problem (most likely) or someone changed the code/schema.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
-
RE: Can this Trigger be done?
You need to write the trigger as if multiple records exist, so do the check as a join between the "inserted" table and the other table and perform the update...
-
RE: Help with tempdb
agreed.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Multi-Instancing and Vendor App Support
Paritioning makes sense in some cases. Not sold on it for the main db, but for cases where you can "archive" data, moving some of it makes sense.
For instances, you...
-
RE: QOD - Answer Format
Good idea. I'll pass along to Brian Knight, the QOD is his thing.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Pet Peeves
Hey, hey, hey. I've seen the US Rowing team and we'd beat the Japanese by a mile.
BTW I used to row, so pick on some other sport.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
-
RE: statistics _WA_
The statistics are used to decide which indexes to use. They help the query optimizer to make decisions.
I'd leave them alone.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
.Viewing 15 posts - 35,881 through 35,895 (of 39,720 total)