RE: Stored Procedures - OUTPUT?
What is the different between SELECT and SET DECLARE @var varchar(100) SELECT @var = 'select * from tablename' SET @var = = 'select * from tablename'
2003-06-06
1 reads
career
RE: DBAs versus SQL Server
There is something of an inverse correlation between the number of knowledgable dba's and knowledgable programmers when it comes to rdbms's. We have less of the latter and try to enforce strict requirements so developers cannot alter anything in production. This makes the dba workload heavier. We are also responsible for performance tuning. I am […]
2003-06-05
2 reads
RE: Stored Procedures - OUTPUT?
Creating a temp table (or table variable) is probably the best way, especially if the procedure is going to get large, or you want to manipulate the output with a sort...
2003-06-05
1 reads
RE: how to use time functions in sql server?
Forgot a ) probably should have been "and" instead of "or". dateadd(mi,30,getdate()) <= field and dateadd(mi,-30,getdate()) >= field Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-06-05
1 reads
RE: how to use time functions in sql server?
dateadd(mi,30,getdate()) <= field or dateadd(mi,-30,getdate() >= field Gregory Larsen, DBA If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples
2003-06-05
1 reads
2003-06-05
RE: Guest account within MASTER
First, Guest account has no any permission to any objects but it is in public role. You can't remove guest account from maste and tempdb. If you revoke permission from public role, everyone will not be able to access the object unless you grant the access specially to the particular user. i would like to […]
2003-06-05
1 reads
RE: Not allowing Restore of Sql Server7 Database
Shas3 is correct. Consider that as far as SQL Server is concerned - SA is GOD. GOD can do anything, you can not stop GOD. But you CAN stop other people/users from pretending to be GOD. Put a strong password on the SA account and don't share it with those who don't need it. Remove […]
2003-06-05
RE: Partition table
I'd like to add something to the note from jpipes about horizontal partitioning. We recently partitioned a 65 million row table into quarterly tables of 10 million or so records each. I followed the instructions in the topic "Creating a Partitioned View" in SQL Server Books Online. These instructions were very useful, and our partitioned […]
2003-06-05
RE: Guest account within MASTER
quote: I've actually done some research on this. Guess I need to put it together in an article. If you can wait a day or so, I'll go find my write-ups. There's one view and one stored procedure, if I remember right, that's absolutely essential. The rest can be undone, but you may break something. […]
2003-06-05
2 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers