You can use a Partitioned View. You would create two tables each with a check constraint on the year column. Then you create a view unioning the two tables together with a union all. The optimizer is smart enough when selecting to select from the correct table if you supply year in the where clause. […]
2003-05-28
Dear Gurus Well, I do think all those (good!) tips can conduct us to a ..."salomonic" idea -- that I'll try (needless to say) just if-and-when that never-ending-loop happens again...: - That's to say: 1º - disconnect IIS; 2º - close IE; 3º - (re)open IE; and 4º - (re)connect IIS. It worths a try!, […]
2003-05-12
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
Ahh, but that's the thing, none of the usual SPs or INFORMATION_SCHEMA items report an incorrect size. And none of the usuall DBCC items report any issues.
2003-05-12
I thought I remembered this one, from SQL Server Magazine UPDATE, May 3 2001... * TIP: MAXIMUM ROW SIZE (contributed by Richard Waymire, rwaymi@microsoft.com) Q. How can I find out the maximum row size for a table in which all the varchars are fully populated? A. The only way to find a SQL Server table's […]
2003-05-12
1 reads
I found this out: 'INSERT INTO ##all_logins SELECT name,'''+ @server_name +''' FROM ' + @sys_table )
2003-05-08
insert into ##temptable select relevant.columns from table1 inner join table2 on pk1 = pk2 where table1.createdate = yesterday and (table1.col1 <> table2.col1 or table1.col2 <> table2.col2 or ... ) You will then have all of the data needed for your email easily accessable.
2003-05-06
2003-05-02
Hi, How about setting the colum type for this column as something like varchar(20) during import and then using the convert(datetime) function to convert this varchar value into a datetime value... -- whoops...the convert datetime for a value like 050203 will convert it to '2005-02-03'...I assume that you need it to be converted to something […]
2003-05-02
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers