Forum Replies Created
Viewing 15 posts - 35,491 through 35,505 (of 39,720 total)
-
RE: upgrading from Access to TSQL
for the first one, you need a table alias, so
select a.* from (select....) a
where a.cnt > 1
For the 2nd, look up CAST in BOL.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
-
RE: How to TEST if statistics should be updated.
Is Auto Update statistics turned on?
It's an interesting question and I thought that reindexing would fix the statistics as well with a new sampling, but perhaps not.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
-
RE: %COMPUTERNAME% does not work
I'm guessing that the osql isn't evaluating the variable properly. Does it invoke other items? Like osql -smyserver -u%username%?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SQL on NAS
I wouldn't put it on NAS. We've had issues with backups to network drives for the reason that SQL Server is not very tolerant of network delays. I wouldn't want...
-
RE: Stars
I like the title change idea. We'll take a look at that.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Is it possible to trigger an external program ?
You can by placing an xp_cmdshell in the trigger, but be careful. The trigger will not complete and the transaction will not complete until the program finishes, which means locks...
-
RE: GREAT 2004 and FORWARD MARCH
Agree and thanks for the note.
Thanks to all for their contributions and thanks that my family, friends, and partners are healthy!
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Effective permissions
Don't grant to users, use roles.
That being said, the permissions matrix is by user/role by object, so you'd probably want to query for a specific object to see the permissions....
-
RE: Stars
Some good points brought up above. Overall, we kind of see the points as a contribution thing, shows us who's contributing to the community and we have tried to reward...
-
RE: Script database objects to file automatically
you can do it with DMO (I think Andy has an article on this) and then run the script from a job.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 -...
-
RE: .
@##^%$$#%$#%#
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Do Hints Work Anymore?
1. I've seen this as well and I have no idea. Some piece of code in the Optimizer is not working as expected.
2.
. send to sqlwish@microsoft.com3....
-
RE: Copying backup causes periodic failure
Most likely the file is in use by some process, either the backup process or some tape process.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SQL Recommendations
I use ASP to query the db and pull stuff out. Visual Studio will help here. I'm sure there are some commercial utilites (http://www.mylittletools.net/scripts/en/home/) and others that can help.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: Recovery of database...
it should be rolling back the transaction and you will have to wait until it completes.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
. send to Viewing 15 posts - 35,491 through 35,505 (of 39,720 total)