RE: UNION into statement fails
I am curious about inserting into a table. Is it better practice to do a 'INSERT INTO <Table Name> SELECT <fields> FROM etc..' instead of 'SELECT <fields> INTO <Table Name> FROM etc...'
2003-06-11
Views
RE: What makes a good developer?
different take on the subject- 1) Good album on headphones (SOAD anyone??) 2) Mug of columbian or a cold beer(if allowed) 🙂 🙂 3) A dog -eared copy of Guru's Guide 4) Boss on vacation
2003-06-11
RE: Previous date's value
If all the dates are consecutive then join the table to itself with date-1. If the dates are not consecutive then join the table to itself with max(date) < date If the dates are not consecutive and you want an entry for all dates between a range then create a table containing all the required […]
2003-06-11
1 reads
RE: Using VPN with Log Shipping
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-06
RE: unsigned ints
You could use a BINARY value. Same storage requirements as INT but you can use all the bits. You may find it cumbersome though, depending on your processing needs, but just an option to consider... CREATE TABLE IPAllocations ( IP BINARY(4) PRIMARY KEY, Octet1 AS convert(smallint, substring(ip,1,1)), Octet2 AS convert(smallint, substring(ip,2,1)), Octet3 AS convert(smallint, substring(ip,3,1)), […]
2003-06-06
RE: TOP 5 Projects for Employees
I'm not going to write a query here. Just some ideas. If you need more help, I'm glad to help you out. Your query will look something like SELECT <all your main stuff here> FROM ... OuterFrom1 WHERE ProjNum IN (SELECT TOP 5 ProjNum FROM ... WHERE OuterFrom1.EmpId = SubQuery1.EmpID) Maybe a bit of explanation […]
2003-06-06
RE: 3241 error
Try launching the trace flag 3111 and see. Even though MS KB says it will happen only if the transaction log back size more than 4GB, I’ve seen this on one of the server with T-Log backup around 500MB
2003-06-05
1 reads
RE: DBAs versus SQL Server
I work for a utility company. We have 18 SQL Server servers running 25 instances, 42 Oracle servers running 58 instances, and ADABASE on the mainframe. There are 3 of us. Adequate to keep things running, not good enough to insure no data loss. Not good enough to keep up with Patches and new features […]
2003-06-05
1 reads
RE: SP with Select * from table for xml auto
Why does the column header matter? You only see it if you save it directly to a file. If you are going to have a 'front-end' to run this t-sql then you can get rid of the header there. If you are looking to save it to file from QA then look at the settings.
2003-05-27
1 reads
RE: SQL/SVR DBA
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-05-12
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