SqlServerKudos - Stories tagged with SQL Server

SQL Server

atom rss
1
kudos
spam Kudos Remove

FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."
published 965 days, 22 hours, 19 minutes ago posted by sasa 969 days, 5 hours, 58 minutes ago
Tuesday, September 29, 2009 2:02:28 PM GMT Saturday, September 26, 2009 6:22:42 AM GMT
FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details." http://support.microsoft.com/kb/970726/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: assertion, error, error log, index, kba, parallel queries, SQL Server
1
kudos
spam Kudos Remove

MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.
published 966 days, 22 hours, 23 minutes ago posted by sasa 969 days, 10 hours, 8 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Saturday, September 26, 2009 2:12:43 AM GMT
MSG 10314 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS or UNSAFE.
As it states on the subject line this is an error that would cause when the system is trying to load assembly due to the permissions, the second part of the subject also needs consideration that server may be running out of resources & security issue. Msg 10314, Level 16, State 11, Line 2 An error occurred in the Microsoft .NET Framework while trying to load assembly id 65536. The server may be running out of resources, or the assembly may not be trusted with PERMISSION_SET = EXTERNAL_ACCESS...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: .NET, access, Assemblies, BOL, CLR, error, Login, login mapping, privileges, Security, sid, SQL Server, versioncontrol
1
kudos
spam Kudos Remove

SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
published 966 days, 22 hours, 23 minutes ago posted by sasa 969 days, 14 hours, 13 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 10:07:43 PM GMT
SQL Server database design goals: Memory, Disk and I/O - maximize the scalability with monitoring
Do you consider the I/O whenever a database design project is assigned? It is one of the primary design goals of all database software is to minimize disk I/O because disk reads and writes are among the most resource-intensive operations. Over the time it may be one of the criteria that extensive usage of data and defautl behaviour on SQL Server builds a buffer pool in memory to hold pages read from the database. While queries are getting designed the code must be optimized and dedicated to minimizing...... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: capacity, disk, i/o, input, Memory, Monitoring, Performance, SQL Server, statistics, Tools
1
kudos
spam Kudos Remove

How to Generate Script along with Data?
published 966 days, 22 hours, 23 minutes ago posted by sasa 969 days, 18 hours, 18 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 6:02:44 PM GMT
How to Generate Script along with Data?
One of the new features available in SQL Server 2008 is scripting the tables along with data (in the form of INSERT statements). Here are the useful links that can help you generating script with data SQL Server 2008 http://www.kodyaz.com/articles/sql-server-script-data-with-generate-script-wizard.aspx SQL Server 2000/2005 http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en...(read more) (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: Script, SQL Server, T-sql
1
kudos
spam Kudos Remove

Generate Fibonacci series - No loop, no recursion
published 966 days, 22 hours, 23 minutes ago posted by sasa 969 days, 22 hours, 19 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 2:01:44 PM GMT
Generate Fibonacci series - No loop, no recursion
Generating the Fibonnaci series generally involves in writing the code which has while loop or a recursive function Peso posted the code using the Common table expression Here are my methods that involve no loop or no recursion 1 Use Quirky update technique declare @fib table ( fib_id bigint , fib_val bigint ) declare @current_val bigint , @previous_val bigint , @new_val bigint --Set how many rows you want to generate the series insert into @fib ( fib_id , fib_val ) select top 30 row_number () over...(re... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: fibonacci series, SQL Server, T-sql
1
kudos
spam Kudos Remove

SQLBits goes west - List of sessions submitted
published 966 days, 22 hours, 23 minutes ago posted by sasa 970 days, 2 hours, 24 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 9:56:45 AM GMT
SQLBits goes west - List of sessions submitted
If you are in Europe then you don't need introduction about SQLBits- a popular conference for SQL Server users in Europe. This time SQLBits goes west which is the fifth from the series. So far it has been a good learning experience (me too) to see experts & users in one place, as usual this time I have submitted the following sessions and you might have observed the icon on the top: Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable...(r... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: business intelligence, Conference, networking, new features, r2, secure, SQL Server, SQLBits, usergroup, Version
1
kudos
spam Kudos Remove

FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008
published 966 days, 22 hours, 23 minutes ago posted by sasa 970 days, 6 hours, 29 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 5:51:45 AM GMT
FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Standard Notification Contents: New and Major Modifications FIX: You receive error messages or data is damaged after you run an SSIS package that contains a data flow task in a low memory situation in SQL Server 2005 or in SQL Server 2008 http://support.microsoft.com/kb/972498/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: agent, data flow, error, fix, kba, low memory, package, SQL Server, SSIS
1
kudos
spam Kudos Remove

Session Voting Open for SQLBits V - don't forget to even if you are not attending!
published 966 days, 22 hours, 23 minutes ago posted by sasa 970 days, 10 hours, 39 minutes ago
Monday, September 28, 2009 1:57:32 PM GMT Friday, September 25, 2009 1:41:46 AM GMT
Session Voting Open for SQLBits V - don't forget to even if you are not attending!
To continue the story about SQLBits V conference and list of sessions that I have submitted , here is news for you to participate in voting. If you are registered on the site you can now vote on the sessions you want to see at the next SQLBits. Voting is Open Have your say on what sessions are chosen for the Saturday. Go to the Community Day Sessions and vote Its vital that you vote so that you get the sessions. If you don't we've no idea it you would prefer index tuning or piano tuning Why it is...(read... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: Conference, DBA, Developer, europe, management, sessions, SQL Server, SQLBits, usergroup, voting
1
kudos
spam Kudos Remove

FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"
published 967 days, 22 hours, 28 minutes ago posted by sasa 970 days, 14 hours, 44 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 9:36:46 PM GMT
FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" http://support.microsoft.com/kb/973103/en-US...(read more) (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: distribution agent, kba, publication, replication, rpc, SQL Server, stream, synchronization, tds
1
kudos
spam Kudos Remove

Professional Development: Internet Image
published 967 days, 22 hours, 28 minutes ago posted by sasa 970 days, 18 hours, 49 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 5:31:47 PM GMT
Professional Development: Internet Image
Writing from the plane. I just wanted to let you know this because it sounds like I am cool. On the way to Sacramento with a short stop in Vegas. Hopefully, I do not miss my plane and end up in a poker tournament for more $ than I can afford against [...] (more)
category: News | clicked: 1 | comment | | source: jasonmassie.com
tags: humor, Professional Development, SQL Server
1
kudos
spam Kudos Remove

Dropping all temp tables
published 967 days, 22 hours, 28 minutes ago posted by sasa 971 days, 2 hours, 59 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 9:21:48 AM GMT
Dropping all temp tables
In SQL Forum one of the posters asked a question about dropping all the temporary tables There are many ways to do this One of the ways to to run the following code declare @sql varchar ( 8000 ) set @sql = '' select @sql = @sql + ' drop table ' + name from tempdb .. sysobjects where xtype = 'u' exec ( @sql ) Published 18 September...(read more) (more)
category: News | clicked: 3 | comment | | source: sqlserver-qa.net
tags: SQL Server, tempdb, T-sql
1
kudos
spam Kudos Remove

No politRics here, comparison of a RDBMS product for best benchmarks and delivers trusted results?
published 967 days, 22 hours, 28 minutes ago posted by sasa 971 days, 7 hours, 4 minutes ago
Sunday, September 27, 2009 1:52:35 PM GMT Thursday, September 24, 2009 5:16:49 AM GMT
No politRics here, comparison of a RDBMS product for best benchmarks and delivers trusted results?
Introduction This is the first post of Facts and Fixtures section here, as a good start I'm beginning this blog section that I could use some 'real world' opinions here, as you can see on this site which is a standard community type site with a motto of 'Knowledge Sharing Network'; being a found of this network I believe in providing real-world facts and figures to my community and users in Cyber World. Every one has got right to share their thoughts and opinion, but at the same it is not a 'good...(read... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: benchmarking, competition, editions, features, interop, marketing, mysql, RDBMS, results, SQL Server
1
kudos
spam Kudos Remove

Disaster Recovery in the Cloud
published 967 days, 22 hours, 28 minutes ago posted by sasa 971 days, 11 hours, 9 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
1
kudos
spam Kudos Remove

SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
published 976 days, 23 hours, 9 minutes ago posted by sasa 986 days, 13 hours, 35 minutes ago
Friday, September 18, 2009 1:12:05 PM GMT Tuesday, September 08, 2009 10:46:15 PM GMT
SQL Server Security, Performance & Tuning (SSQA.net) : SQL Server: Monitor and Manage Database Maintenance issues - DBCC, backup and spotlight on tempdb and Transaction log backup performance
The subject line of this post is a common factor that every DBA might have (once in lifetime).  Performance Monitoring is a big subject when it comes to practice,  many factors include such as what to monitor, how often, and 'basic' rules of thumb. For the sake of performance you cannot simply compromise any SLA or Availability of application, there needs to be an effective approach to monitor and manage Database Maintenance issues in specific to DBCC,... (more)
category: News | clicked: 2 | comment | | source: sqlserver-qa.net
tags: applications, Best Practices, cpu, DMV, dynamic, kerberos, maintenance plan, Memory, performance monitoring, sla, SQL Server
1
kudos
spam Kudos Remove

Directly Opening a Solution in SQL Server Management Studio
published 986 days, 23 hours, 53 minutes ago posted by sasa 994 days, 18 hours, 8 minutes ago
Tuesday, September 08, 2009 12:27:56 PM GMT Monday, August 31, 2009 6:13:13 PM GMT
Directly Opening a Solution in SQL Server Management Studio
Directly Opening a Solution in SQL Server Management Studio I use Solutions a lot in SQL Server Management Studio (SSMS), and you should be aware of this simple tip: If you want to open a Solution without having to open SSMS and then jumping through all the menus, just double-click the solution name in the Windows folder. It will automatically open the Solution and SSMS at the same time. This tip, by the way, also works with any .SQL files, unless you've installed another product that has that file ass... (more)
category: Management | clicked: 0 | comment | | source: blogs.msdn.com
tags: DBA, Developer, Development, SQL Server, SQL Server Management Studio, SSMS, Tips
1
kudos
spam Kudos Remove

Visual Studio and Deployment of SQLCLR Assemblies
published 986 days, 23 hours, 53 minutes ago posted by sasa 994 days, 18 hours, 32 minutes ago
Tuesday, September 08, 2009 12:27:56 PM GMT Monday, August 31, 2009 5:48:59 PM GMT
Visual Studio and Deployment of SQLCLR Assemblies
Every so often, there is this question coming up in the SQLCLR news groups / forums about Visual Studio and deployment of assemblies to SQL Server;  “why can I not deploy this, that, or the other assembly to SQL Server using the ‘SQL Server Project’ project type from Visual Studio”. The short answer is that Visual Studio is kind of brain dead – that is why. The slightly longer answer is that … Well, that is what this document tries to answer.Background “Once upon a time, a long long time ago …”. Well m... (more)
category: Management | clicked: 4 | comment | | source: www.sqldevelop.com
tags: .NET, Assemblies, CLR, SQL Server, SQLCLR
1
kudos
spam Kudos Remove

SQL Server – Multiple CTE in One SELECT Statement Query
published 1012 days, 20 hours, 8 minutes ago posted by sasa 1017 days, 18 hours, 27 minutes ago
Thursday, August 13, 2009 4:13:26 PM GMT Saturday, August 08, 2009 5:53:53 PM GMT
SQL Server – Multiple CTE in One SELECT Statement Query
I have previously written many articles on CTE. One question I get often is how to use multiple CTE in one query or multiple CTE in SELECT statement. Let us see quickly two examples for the same. I had done my best to take simplest examples in this subject. Option 1 : / Method 1 / ;WITH CTE1 AS (SELECT 1 AS Col1), CTE2 AS (SELECT 2 AS Col2) SELECT CTE1.Col1,CTE2.Col2 FROM CTE1 CROSS JOIN CTE2 GO Option 2: / Method 2 / ;WITH CTE1 AS (SELECT 1 AS Col1), CTE2 AS (SELECT COL1+1 AS Col2 FROM ... (more)
category: Query | clicked: 7 | comment | | source: blog.sqlauthority.com
tags: CTE, Pinal Dave, SQL, SQL Authority, SQL Joins, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology
1
kudos
spam Kudos Remove

How to display detailed data below each header data?
published 1015 days, 21 hours, 47 minutes ago posted by sasa 1019 days, 20 hours, 14 minutes ago
Monday, August 10, 2009 2:33:32 PM GMT Thursday, August 06, 2009 4:07:20 PM GMT
How to display detailed data below each header data?
One of my friends asked me if it possible to generate Detailed data for each Header data without using a Cursor or while loop. (The output is something like the one usually seen via reporting tool). He wanted the result to be output to text file Consider the jobs and employee tables from pubs database select jobid, jobdesc from jobs select jobid,empid,fname,lname from employee The task is to show employee det... (more)
category: Query | clicked: 3 | comment | | source: sqlblogcasts.com
tags: detail, header, report, SQL Server, T-sql
1
kudos
spam Kudos Remove

Editing Configuration files : SSIS Nugget
published 1015 days, 21 hours, 47 minutes ago posted by sasa 1020 days, 14 hours, 56 minutes ago
Monday, August 10, 2009 2:33:32 PM GMT Wednesday, August 05, 2009 9:24:33 PM GMT
Editing Configuration files : SSIS Nugget
Its been a long-g-g-g-g time since I did a SSIS-related post so here’s a little ditty that I picked up while reviewing some internal stuff today. Editing SSIS configuration (i.e. .dtsConfig) files isn’t particularly easy. Most people I see who try to do this use a traditional text editor like Notepad but that isn’t a great experience because the contents don’t look particularly friendly when you open them up. Observe: Instead you may wish to use Visual Studio which, if you’re messing about with SSIS ... (more)
category: Warehousing | clicked: 2 | comment | | source: blogs.conchango.com
tags: configurations, Nugget, SQL Server, SQL Server Integration Services, SSIS
1
kudos
spam Kudos Remove

Code Collapse and Expand Feature in SQL Server Management Studio 2008
published 1023 days, 30 minutes ago posted by sasa 1026 days, 18 hours, 34 minutes ago
Monday, August 03, 2009 11:51:18 AM GMT Thursday, July 30, 2009 5:47:17 PM GMT
Code Collapse and Expand Feature in SQL Server Management Studio 2008
Code Collapse and Expand Feature in SQL Server Management Studio 2008 In SQL Server Management Studio 2008, whenever you have a "block" of code (BEGIN....END, etc) SSMS will put a little plus-sign in the margin and allow you to "collapse" that block of code so you only see the BEGIN, not stuff underneath. If you're working with a really large set of code, that's helpful. But I got an e-mail from a friend that said her SSMS didn't do that. I was kind of surprised, since I never had to do anything to mak... (more)
category: Management | clicked: 19 | comment | | source: blogs.msdn.com
tags: DBA, Developer, Development, SQL Server, SQL Server 2008, SQL Server Management Studio, SSMS, Tips
Previous 1 2 ... 11 12 13 14 15 16 17 18 19 20 Next