SqlServerKudos - Stories tagged with SQL Server 2008

SQL Server 2008

atom rss
1
kudos
spam Kudos Remove

Creating a unique constraint on a column that allows nulls
published 4 hours, 35 minutes ago posted by sasa 1 day, 6 hours, 39 minutes ago
Saturday, July 31, 2010 3:23:24 PM GMT Friday, July 30, 2010 1:18:30 PM GMT
Creating a unique constraint on a column that allows nulls
Primary keys, unique indexes and unique constraints all enforce uniqueness. The difference between the primary key and the unique index/constraint is that the primary key does not allow any NULL values. However whilst the unique index/constraints do allow...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found
published 15 days, 5 hours, 40 minutes ago posted by sasa 24 days, 6 hours, 11 minutes ago
Friday, July 16, 2010 2:17:41 PM GMT Wednesday, July 07, 2010 1:47:09 PM GMT
SQL Server Installation : SMO related problems and client toosl issue - 'Microsoft.SqlServer.Management.Smo.Table.UrnSuffix' not found
A typical problem occurs when SQL Server client tools do have any issues. There is no easy way to say that SSMS (client tools) are corrupted, unless you can reproduce the same issue on other machine it cannot be assured. If it is a bug from tools you can easily file them on Microsoft connect site and preferably search for similar problem before posting a new one. Here is an interesting issue happened on my laptop and not on other desktop when I was trying to connect to a SQL intance (2008 version)....(re... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: client tools, corrupted, installallation, Maintenance, SMO, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
published 49 days, 8 hours, 12 minutes ago posted by sasa 58 days, 10 hours, 33 minutes ago
Saturday, June 12, 2010 11:45:32 AM GMT Thursday, June 03, 2010 9:24:39 AM GMT
SQL Server 2008 R2 setup error: SQLEngine: --SqlServerServiceSCM: Starting SQL via SCM (-mSqlSetup ………)
A bit of background on the installation setup of SQL Server 2008 (SP1) release onwards, that you need slipstream the installation. This is nothing but you could just install the SQL 2008 + Service Pack release as one time, which is a time-saving mechanism. Peter Saddow from SQL Server development team has shown example from the blog about how it looks when you install (see below): Coming back to the subject line I was presented with the error when trying to perform a slipstream installation of SQL...(rea... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: download, Installation, integration services, package, slipstream, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

Scream if you want to go faster
published 65 days, 9 hours, 24 minutes ago posted by sasa 72 days, 11 hours, 52 minutes ago
Thursday, May 27, 2010 10:33:51 AM GMT Thursday, May 20, 2010 8:05:34 AM GMT
Scream if you want to go faster
My session for 24hrs of pass on High Performance functions will be starting at 11:00 GMT thats migdnight for folks in the UK. To attend follow this link https://www.livemeeting.com/cc/8000181573/join?id=N5Q8S7&role=attend&pw=d2%28_KmN3r The rest...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: PASS, Performance, Query Tuning, SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Certification - a database platform primer for your career path
published 72 days, 9 hours, 52 minutes ago posted by sasa 80 days, 12 hours, 12 minutes ago
Thursday, May 20, 2010 10:05:28 AM GMT Wednesday, May 12, 2010 7:46:08 AM GMT
SQL Server Certification - a database platform primer for your career path
When you need to upgrade your knowledge then training is required, at the same time certifications will help you to keep up on what you have learned! There is a big debate on the web about whether certifications are important in your career or not, the bottomline is if you do not know the stuff or unable to answer few basic technical questions, it does'nt matter how many certifications you have then you will not get the job, well I'm not starting the same discussion here. But in the recent times...(read ... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Certification, path, real world, SQL Server, SQL Server 2008, SQL Server 2008 R2, study, technical
1
kudos
spam Kudos Remove

Spatial data in the UK
published 107 days, 12 hours, 33 minutes ago posted by sasa 116 days, 14 hours, 12 minutes ago
Thursday, April 15, 2010 7:24:59 AM GMT Tuesday, April 06, 2010 5:45:30 AM GMT
Spatial data in the UK
I am just loving the fact that the Ordance Survey has now released a huge amount of data that can be used freely. I’ve downloaded the Panorama (tm) data http://www.ordnancesurvey.co.uk/oswebsite/products/land-form-panorama-contours/index.html . which...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: Spatial, SQL Server 2008
1
kudos
spam Kudos Remove

Enabling super single user mode with SQL Server
published 117 days, 13 hours, 17 minutes ago posted by sasa 126 days, 13 hours, 47 minutes ago
Monday, April 05, 2010 6:40:30 AM GMT Saturday, March 27, 2010 6:11:02 AM GMT
Enabling super single user mode with SQL Server
I recently got an email from a fellow MVP about single user mode. It made me think about some features I had just been looking at and so I started playing. The annoyance about single user mode for SQL Server is that its not really single user, but more...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, Tips and Tricks
1
kudos
spam Kudos Remove

SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.
published 126 days, 13 hours, 57 minutes ago posted by sasa 135 days, 14 hours, 33 minutes ago
Saturday, March 27, 2010 6:01:01 AM GMT Thursday, March 18, 2010 5:25:06 AM GMT
SQL Server Failover Cluster and Filestream feature enabled, issues surronding the failover and failback.
At the first instance the error is clear that some problem with SQL resource that was allocated to the Cluster resource. Just a background on SQL Server Failover Clustering, that the server cluster consists of a failover cluster instance that runs under Cluster Services (MSCS). The instance of SQL Server might be hosted by Microsoft MSCS-based nodes that provide the Microsoft Server Cluster, say if problems exist on the nodes that host the server cluster, those problems may manifest themselves as...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Cluster, failover, filestream, kba, SQL Server, SQL Server 2008
1
kudos
spam Kudos Remove

SSIS - XML Source Script
published 132 days, 14 hours, 22 minutes ago posted by sasa 141 days, 15 hours, 1 minute ago
Sunday, March 21, 2010 5:35:37 AM GMT Friday, March 12, 2010 4:57:12 AM GMT
SSIS - XML Source Script
The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early versions of Biztalk with loaded the whole document into memory to map from one document type to another. This was fine for small documents but was an absolute killer for large documents. You therefore need a... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: c#, SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML
1
kudos
spam Kudos Remove

SQLBits Videos available now available
published 172 days, 19 hours, 27 minutes ago posted by sasa 182 days, 6 hours, 52 minutes ago
Tuesday, February 09, 2010 12:30:58 AM GMT Saturday, January 30, 2010 1:05:33 PM GMT
SQLBits Videos available now available
You can watch all the sessions from SQLBits V now. They are available for download or for viewing online. If there is a delay then just wait, the videos are high quality and so are very large. These are the links to all the sessions (more)
category: News | clicked: 1 | comment | | source: sqlblogcasts.com
tags: free, SQL Server 2008, SQL Server 2008 R2, Training
1
kudos
spam Kudos Remove

Time is no use for recording Time
published 178 days, 19 hours, 53 minutes ago posted by sasa 188 days, 7 hours, 18 minutes ago
Wednesday, February 03, 2010 12:05:18 AM GMT Sunday, January 24, 2010 12:40:20 PM GMT
Time is no use for recording Time
I was asked by a client about the new Time datatype in SQL 2008. They wanted to store the duration of some work so they could use the nice date time functions to get the hours, minutes, seconds etc. However you can't use the Time date type for that, because it can only hold time up to midnight after that it roles around to 0. Not much use if something takes longer than 24 hrs to run. If you would like to have such a feature then vote for the reccomendation for an interval data type. https://connect.... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2008, Suggestions, Tips and Tricks
1
kudos
spam Kudos Remove

XML Validation in SQL Server Intergration Services
published 181 days, 20 hours, 7 minutes ago posted by sasa 191 days, 3 hours, 56 minutes ago
Saturday, January 30, 2010 11:50:28 PM GMT Thursday, January 21, 2010 4:01:27 PM GMT
XML Validation in SQL Server Intergration Services
I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL 2005 so you can imagine it was written along time ago, XML wasn't as standardised. So what if you want to validate an XML document against a XSD Schema. Well in true SQL Server Integration services mode th... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: SQL Server 2005, SQL Server 2008, SSIS - Integration Services, Tips and Tricks, XML
1
kudos
spam Kudos Remove

User defined function performance is awful, Micorosft please sort this out
published 187 days, 20 hours, 33 minutes ago posted by sasa 197 days, 4 hours, 27 minutes ago
Sunday, January 24, 2010 11:25:16 PM GMT Friday, January 15, 2010 3:30:46 PM GMT
User defined function performance is awful, Micorosft please sort this out
User defined functions looked like something great when they were introduced in SQL 2005. They are a very logical step to make more code reuseable by wrapping common code in functions. It is an approach that is in development 101 and something everyone does and looks to doing. So what is the problem with SQL Server. Well the issue is that whilst there are great from a reducation of duplicated code the performance sucks, and sucks big time. I wrote about this a year ago  and have spoke about it at m... (more)
category: News | clicked: 0 | comment | | source: sqlblogcasts.com
tags: Bugs, Performance, Query Tuning, SQL Engine, SQL Profiler, SQL Server 2005, SQL Server 2008, Tips and Tricks, TSQL
2
kudos
spam Kudos Remove

Ozziemedes on SQL Server: Mastering The Metadata: Part 1 (Tables #1)
published 193 days, 21 hours, 1 minute ago posted by http://ozziemedessql.blogspot.com/http://ozziemedessql.blogspot.com/ 200 days, 3 hours, 18 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 4:39:51 PM GMT
Ozziemedes on SQL Server: Mastering The Metadata: Part 1 (Tables #1)
In this post, I’m going to outline the core metadata SQL Server 2008 uses for Tables, and how you might be able to use this metadata in a useful manner.  In this post, I’ll only go as far as outlining the potential for using table metadata to discover storage characteristics of the table.  I’ll provide more detailed examples in my next post of how you can put this to work.  Before we begin, a brief history lesson to do some context setting. Once upon a time in the distant past, a relational database... (more)
category: Query | clicked: 5 | comment | | source: ozziemedessql.blogspot.com
tags: Metadata, MSSQL, SQL Server 2008, System Catalog, T-sql
1
kudos
spam Kudos Remove

SQL Server Migration Assistant for MySQL v1.0 - CTP1
published 193 days, 21 hours, 1 minute ago posted by sasa 200 days, 8 hours, 52 minutes ago
Monday, January 18, 2010 10:56:27 PM GMT Tuesday, January 12, 2010 11:05:50 AM GMT
SQL Server Migration Assistant for MySQL v1.0 - CTP1
SQL Server Migration Assistant is one of best used tool when there is a huge effort required to migrate the database from other data sources such as MS Access, Oracle & MySQL. As a part of Microsoft Partner network communication I have received this exciting news about SSMA for MySQL which is available for download freely from SSMA2008-MySQLv1.0_CTP1 which is for SQL Server 2008 version and SSMA2005-MySQLv1.0_CTP1 for SQL Server 2005 version. SSMA for SQL 2008 can be used to migrate data from...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: 2005, Documentation, download center, license, migration, SQL Server, SQL Server 2008, ssma, Version
1
kudos
spam Kudos Remove

Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
published 225 days, 23 hours, 20 minutes ago posted by sasa 235 days, 11 hours, 33 minutes ago
Thursday, December 17, 2009 8:37:44 PM GMT Tuesday, December 08, 2009 8:25:15 AM GMT
Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
One of the SQL Server 2008 upgrade process hampered with the error on the subject line and following text box was displayed: For some reason the similar issue hasn't been displayed when Upgrade Advisor has been chosen to find the first hand issues, as per http://sqlserver-qa.net/blogs/tools/archive/2008/01/22/upgrade-blurg.aspx and http://sqlserver-qa.net/blogs/tools/archive/tags/upgrade+advisor/default.aspx posts here. Coming to the root cause of the issue one of the KBA refers that .... this issue...(r... (more)
category: News | clicked: 0 | 2 comments | | source: sqlserver-qa.net
tags: access, policy based framework, sa, Security, SQL Server 2008, SQLServer, Upgrade, upgrade advisor
1
kudos
spam Kudos Remove

More testing of Unicode Compression in SQL Server 2008 R2
published 285 days, 4 hours, 35 minutes ago posted by sasa 294 days, 22 hours, 1 minute ago
Monday, October 19, 2009 3:22:40 PM GMT Friday, October 09, 2009 9:56:42 PM GMT
More testing of Unicode Compression in SQL Server 2008 R2
Background Several weeks ago, I ran some tests on the new implementation of Unicode Compression in SQL Server 2008 R2 - both space-related and performance-related.  Of course it was pointed out that my performance tests were somewhat flawed, because I was using data from a very wide and atypical variety of characters sets.  I also didn't like that I was comparing too many different things in the same pass.  So, I thought I would run one more battery of tests, and right a couple of wrongs. So this time ... (more)
category: News | clicked: 2 | comment | | source: sqlblog.com
tags: Data Compression, SQL Server 2008, SQL Server 2008 R2, Unicode compression
1
kudos
spam Kudos Remove

SQL Server challenge: show me trace flag 1118 is significant
published 293 days, 5 hours, 5 minutes ago posted by sasa 302 days, 23 hours, 37 minutes ago
Sunday, October 11, 2009 2:53:16 PM GMT Thursday, October 01, 2009 8:20:54 PM GMT
SQL Server challenge: show me trace flag 1118 is significant
Here is a SQL Server challenge as I have failed so far:   Describe a reproducible workload that would see significant throughput improvement when trace flag 1118 is enabled.   I have seen a lot of chatters, anecdotes, and stories on the impact of trace flag 1118 on reducing tempdb contentions. But I have not seen any concrete evidence or test cases that actually show its impact on SQL Server 2005 or SQL Server 2008. The empiricist in me just itches for some solid data points.   I have also talked... (more)
category: News | clicked: 1 | comment | | source: sqlblog.com
tags: Benchmark, Best Practices, SQL Server 2008, tempdb, Trace flags, Waits
1
kudos
spam Kudos Remove

Can you be too Thorough?
published 305 days, 5 hours, 55 minutes ago posted by sasa 308 days, 5 hours, 20 minutes ago
Tuesday, September 29, 2009 2:02:28 PM GMT Saturday, September 26, 2009 2:37:41 PM GMT
Can you be too Thorough?
Can you take thoroughness to a fault? There are some things that cannot be taken too far like intelligence. In a business setting, have you ever met someone who was just too smart(competitors do not count)? How about too honest? Too skilled? Too good with customers? I do not think thoroughness fails into this category [...] (more)
category: News | clicked: 1 | comment | | source: jasonmassie.com
tags: DBA, Professional Development, SQL Server, SQL Server 2008, twitter
1
kudos
spam Kudos Remove

Disaster Recovery in the Cloud
published 307 days, 6 hours, 5 minutes ago posted by sasa 310 days, 18 hours, 46 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 1:11:51 AM GMT
Disaster Recovery in the Cloud
Disclaimer: The enterprise Infrastructure as a Service(IaaS) that I will be using is for offered by the company I work for. I have been there 10 years and I am proud of our product set so I may be a little bias. However, these steps should be similar for most IaaS offerings like that of [...] (more)
category: News | clicked: 1 | comment | | source: jasonmassie.com
tags: cloud, disaster recovery, HA, Hardware, IaaS, SQL Server, SQL Server 2008
Previous 1 2 3 Next