Recent update: 2008-3-21
There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc. If we envision db with a ...
Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...
I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets sp_syscollector_create_collection_set didn't ...
There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc. If we envision db with a ...
Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...
Hello! I have a few questions (and suggestions) related to the new HierarchyID datatype in SQL Server 2008 (Katmai). In general, I'm really pleased to see a native hierarchical datatype. Having tested various tree operations using the new datatype over the weekend, it looks like a sound ...
268 byte By
AkashC at 2008-2-27
Hi, as per the BOL, In the "Optimizing Data Warehouse Query Performance Through Bitmap Filtering" the cost of Clustered Index Scan as well as Table Scan takes more time in Katmai according to sql Server 2008. Can you verify it please.
I read in a blog I as pointed to that the compression indexes are built online -- how is this done, live page-by-page so the impact on query is only a single page? Is it done like a shadow approach using snapshot and then switched over?
Sorry - -a little new to SQL Server, but I see there is a single choice of a page at 8KB. Is there a limit to the # of rows I can get on a page outside of calculating header information and the size of each row? I know that DB2 (and I think Oracle) have actual architecual limits on the number ...
<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>
<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>
<font face="Times New Roman">Does SQL 2008 still support DB-LIB or not ?</font> <font face="Times New Roman">Thanks!</font>
<font face="Times New Roman" size=2>Can you give me some details or links on the improvements to database mirroring in SQL 2008? </font>
There are still a bunch of questions and recommendations needed about the new Filestream datatype. I guess it is transactionnally consistent (not like Oracle's BFile), but what are the impacts on the transactional log? What are the recommended ways to use it? etc. If we envision db with a ...
I read the BOL, besides the "Disk Usage" collection set, are there other collection sets to be added? What are the various collections sets that we can add. Can we add performance collection sets? The sproc for adding collections sets sp_syscollector_create_collection_set didn't ...
268 byte By
AkashC at 2008-2-19
Hi, as per the BOL, In the "Optimizing Data Warehouse Query Performance Through Bitmap Filtering" the cost of Clustered Index Scan as well as Table Scan takes more time in Katmai according to sql Server 2008. Can you verify it please.
<font face="Times New Roman">Does SQL 2008 still support DB-LIB or not ?</font> <font face="Times New Roman">Thanks!</font>
Will SQL Server 2008 provide support for nested tables (tables within a column)?
268 byte By
AkashC at 2008-2-16
Hi, as per the BOL, In the "Optimizing Data Warehouse Query Performance Through Bitmap Filtering" the cost of Clustered Index Scan as well as Table Scan takes more time in Katmai according to sql Server 2008. Can you verify it please.
With SQL 2005, using the NOEXPAND hint can result in an error: Msg 8171, Level 16, State 2, Line 1 Hint 'noexpand' on object 'dbo.ervStats' is invalid. I haven't tried it with 2008 yet but I expect the same behavior. That behavior can cause problems and I would like to understand the ...
I've been trying out the XEvent functionality and like what I see so far. But I'm unable to get the ETW target working at all. Host operating system is Windows 2K3 SP1. I've tried a few examples from BOL, crufted up a few CREATE/ALTER EVENT SESSION statements of my own, tried accepting ...
With SQL 2005, using the NOEXPAND hint can result in an error: Msg 8171, Level 16, State 2, Line 1 Hint 'noexpand' on object 'dbo.ervStats' is invalid. I haven't tried it with 2008 yet but I expect the same behavior. That behavior can cause problems and I would like to understand the ...
In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are. ...
<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>
I've been trying out the XEvent functionality and like what I see so far. But I'm unable to get the ETW target working at all. Host operating system is Windows 2K3 SP1. I've tried a few examples from BOL, crufted up a few CREATE/ALTER EVENT SESSION statements of my own, tried accepting ...
In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are. ...
Will we ever get Before (not instead of) triggers and Row triggers? Whenever I have to convert an Oracle application or have a moderately complex application I always curse MS and wonder why every DB except MS has Before and Row based triggers. Could you at least tell me why MS doesn't add ...
I cant find feature to audit executin of statements on table level (I read somewhere that is one of new feature of SQL 2008). For an exemple to now who is make an UPDATE, INSERT or DELETE statements.
Hi, We need to capture all the activity in SQL database, for auditing purposes. Can we audit the activity inside the Katmai to capture SELECTs activity? Remember that this is for auditing purposes. Regards,
Will this be supported in SQL Server 2008: Select * From [ServerName\InstanceName].DatabaseName.SchemaName.FunctionName('Parameter') ? Thanks. David Walker
<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>
<font face=Arial></font> <font face=Verdana>Is this issue handled in Katmai?</font>
<font face=Arial size=2>Is SS08 compression going to help me with my XML. The Primary index is really just a table it appears, so I was hoping to compress that ... plesae? <img height=19 alt=Smile src=" http://forums.microsoft.com/MSDN/emoticons/emotion-1.gif" width=19></font>
<font face=Arial size=2></font> I read in a blog I as pointed to that the compression indexes are built online -- how is this done, live page-by-page so the impact on query is only a single page? Is it done like a shadow approach using snapshot and then switched over?
Sorry - -a little new to SQL Server, but I see there is a single choice of a page at 8KB. Is there a limit to the # of rows I can get on a page outside of calculating header information and the size of each row? I know that DB2 (and I think Oracle) have actual architecual limits on the number ...
266 byte By
nielsb at 2008-2-7
I guess the Subject says it all: Is FILESTREAM in the latest CTP or not? The reason I'm asking is that when searching the latest BOL, there are pointers to FILESTREAM, but when trying to use it in code I'm getting an incorrect syntax error. Thanks! Niels
<font face=Arial size=2>Can someone please tell me if there are any changes planned for the database file format? If so, will the files be updateable to the new format?</font> Thanks, Scott
Hi all, Some feature availability and capability questions (specifics would be great, but ballpark estimates are better than nothing ). First off, which CTP will deliver the - DB encryption improvements? - Performance data warehouse? - DB mirroring improvements? - DB (row/data) compression? - ...
I have submitted this bug to microsoft connect, but I thought I would add it here to further the discussion. Here is how to reproduce it in the most simplest of terms by using a calculated date search on a date field:/* To prevent any potential data loss issues, you should review this script in ...
Will SQL Server 2008 provide support for nested tables (tables within a column)?
Hello everyone, after the CTP4 installation i found a new database called MDW. Who know what is this catalag and its purpose? Thank you. Simon
I cant find feature to audit executin of statements on table level (I read somewhere that is one of new feature of SQL 2008). For an exemple to now who is make an UPDATE, INSERT or DELETE statements.
Any details on this? I was at TechEd and heard about it -- a bit. I understand the prefix portion of the compression algorithm and how its placed on the page. But what is the dictionary for? If I found a pre-fix that's common to 3 DIFFERENT values, would it change the prefix or migrate the ...
I have Orcas (VisualStudio 2008) and Katmai (SQL Server 2008) installed on the same machine, but Orcas will not allow me to add a data connection to the Katmai database. It goes through the wizard and the connection tests okay, but then I get a message saying it doesn't support anything above ...
210 byte By
AkashC at 2008-2-4
<font face=Arial size=2>Hi, </font> Unable to find the resource governor. If it's available in the June CTP can tell me where to locate it and if its not there whn can we possibly get it.
308 byte By
AkashC at 2008-2-4
Hi, as per the BOL, In the "Optimizing Data Warehouse Query Performance Through Bitmap Filtering" the cost of Clustered Index Scan as well as Table Scan takes more time in Katmai according to sql Server 2008. Can you verify it please. ...
Phil move this post to SQL 2005 forum.I suppose my lack of English was the reason, so I post it again.I'm working with DTA Katmai SQL Server 2008. Runing the next query using DTA: select LTrim(RTrim(CodCtaCte)) as CodCtaCte, Nombre from CtaCtes where CuePrefi = 'C' order by Nombre with SQL ...
With SQL 2005, using the NOEXPAND hint can result in an error: Msg 8171, Level 16, State 2, Line 1 Hint 'noexpand' on object 'dbo.ervStats' is invalid. I haven't tried it with 2008 yet but I expect the same behavior. That behavior can cause problems and I would like to understand the ...
Hi, We need to capture all the activity in SQL database, for auditing purposes. Can we audit the activity inside the Katmai to capture SELECTs activity? Remember that this is for auditing purposes. Regards,
108 byte By
HPA at 2008-2-2
Hello, With longhorn server and SQL Server 2008 will we be able to have more than 64 CPUS?