Data Compression in SQL Server 2005 (Believe it !!)
That’s correct. SQL Server 2005 SP2 supports data compression using Vardecimal data type.
2008-03-18
4,114 reads
Data Compression
RE: Matrix - converting rows to percentage of column total
You could try adding a static column to the matrix and then changing the row value to along the lines of = ReportItems!txtMyField.Value / SUM(Fields!myField.Value, "myDataRegion") and then format the textbox with the 'p' format code (for percentage).
2005-05-24
RE: Cannot import Paradox file from the Server ???
Hi Fraser,If you can get access to the database through Access, do what i do when I can't get into Oracle and get to the Paradox data through a link to Access... I have found that this works well for me. Do the Link to the database / tables in Access and use the DTS […]
2005-02-22
RE: Retrieving the ID of a record just inserted
If you can add one more column to your table than: create table FIFO(xxx,xxx,xxx, GUID uniqueidentifier) declare @GUID uniqueidentifier set @GUID = NewID() INSERT INTO FIFO ( xxx,xxx,xxx,xxx, GUID  VALUES( xxx,xxx,xxx,xxx, @GUID  // Insert recordSELECT UID AS Value FROM FIFOwhere GUID = @GUID // Get the UID of the record just inserted It works much faster than using temporary table, especially if […]
2004-08-30
query question
Hi, All: Here is a question that I could not figure out. Please share your idea if you know the answer... I have a table: id col1 col2 --- ----- ----- 1 A kk 1 B jj 1 C bb 2 D qq 2 E ffThe following should be the result: id col1 col2 --- ------- -------- 1 A,B,C kk,jj,bb 2 […]
2004-05-14
Dumb SQL question....
I have the following query that retrieves a list of users that belong to a particular group (in this case groupid 1).SELECT su.sysuser_firstname, su.sysuser_lastname, sug.sysuser_id, sug.sysusergroup_id FROM sysuser_sysusergroup sug, sysuser su WHERE sysusergroup_id = '1' AND sug.sysuser_id = su.sysuser_id ORDER BY su.sysuser_lastname, su.sysuser_firstnameI need to figure out a query that will return only users that […]
2004-05-13
4 reads
RE: Linked Server
Regarding linked serversLinked servers are the way a SQL Server Instance tracks theOLEDB provider and connection context that it applies to queries containing four part names. Server.Database.Owner.ObjectRather than using the rowset functions like Openquery(...), Openrowset(...), and OpenDataSource(...) in in-line tables declarations in the FROM clauseeg. You get this syntax if a linked server is define […]
2004-03-23
RE: What am I missing?
I have never tried what you are trying. I usually explicitly create temp tables in my sp's because it helps reduce compiles. What is the point of adding the new field? Is there another way to reach your final goal?
2004-03-12
RE: Log Shipping - Do we still do Full Backups
The backup itself will not truncate the log it will checkpoint it however so that SQL knows that it can recover from that point forward. The log backups will continue as normal.There is inherent magic...as there are in a lot of these things....
2004-03-10
RE: SQL Construct
try:INSERT INTO UNRESOLVED (CaseNbr)SELECT T3.CaseNbr FROM Table3 T3 LEFT OUTER JOIN (Select CaseNbr From Table 1 UNION Select CaseNbr from Table 2  Q ON T3.CaseNbr =Q.CaseNbr WHERE Q.CaseNbr is Null
2004-03-02
Blogs
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...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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