DotNetShoutout - Stories tagged with SQL Server

SQL Server

atom rss
4
Shouts
spam Shout it Mute it

Video on StaticKeyword.mp4
posted by questpondquestpond 649 days, 14 hours, 3 minutes ago
Friday, September 09, 2011 12:28:23 PM GMT
StaticKeyword.mp4 .NET and C# interview questions (more)
category: Web Dev | clicked: 1 | comment | | source: youtu.be
tags: SQL Server, .Net Interivew Questions, C# interview Questions, Asp.Net Interview Question
4
Shouts
spam Shout it Mute it

c# interview questions :- Prove that only 1 instance of the object is created for static classes ?
posted by questpondquestpond 649 days, 15 hours, 14 minutes ago
Friday, September 09, 2011 11:17:12 AM GMT
In this video we will try to prove that only 1 instance exists for a static class. .NET and C# interview questiona (more)
category: Web Dev | clicked: 5 | comment | | source: youtu.be
tags: SQL Server, WCF Interview Questions, ASP .net interview questions, .Net Interivew Questions, C # Interview Questions
6
Shouts
spam Shout it Mute it

T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
published 648 days, 17 hours, 1 minute ago posted by dharadhara 649 days, 18 hours, 19 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Friday, September 09, 2011 8:12:13 AM GMT
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I will show you guys a couple of new windowing functions, that goes along with the OVER clause. (more)
category: Data | clicked: 10 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Lag function in Denali CTP 3
published 648 days, 17 hours, 1 minute ago posted by dharadhara 649 days, 18 hours, 21 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Friday, September 09, 2011 8:10:38 AM GMT
Lag Function Purpose: This function returns result set starting from the previous row in the table. Syntax: Lag(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)
category: Data | clicked: 10 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali, CTP
6
Shouts
spam Shout it Mute it

Logging off disconnected users
published 648 days, 17 hours, 1 minute ago posted by dharadhara 650 days, 17 hours, 45 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:41 AM GMT
And now for something completely different… As it is essential for a DBA to know his/her way around in server administration, let’s think of something else for a minute. If your IT department consists of more than 2 people, you most likely... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, RDP
6
Shouts
spam Shout it Mute it

Lead function in Denali CTP 3
published 648 days, 17 hours, 1 minute ago posted by dharadhara 650 days, 17 hours, 45 minutes ago
Saturday, September 10, 2011 9:30:21 AM GMT Thursday, September 08, 2011 8:46:12 AM GMT
Lead Function Purpose: This function returns result set starting from the next row in the table. Syntax: Lead(expression [,offset [,default] ] ) over( [ PartitionByclause] order by clause) Where, Expression => A table column or built-in function... (more)
category: Data | clicked: 19 | 1 comment | | source: beyondrelational.com
tags: SQL Server, denali
6
Shouts
spam Shout it Mute it

BCP & large BULK operations made faster – switch between FULL & BULK-LOGGED recovery models
published 650 days, 19 hours, 20 minutes ago posted by dharadhara 651 days, 16 hours, 39 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:49 AM GMT
Recently, a friend told me that they were experiencing performance issues in production when importing data from 3rd party interfaces at the end of the day. The entire import was done via BCP and at a time when no users were logged into the system. Also... (more)
category: Data | clicked: 7 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

MSBI # 26 – SSIS # 13 – Control Flow Tasks # 8 – ActiveX Script Task
published 650 days, 19 hours, 20 minutes ago posted by dharadhara 651 days, 16 hours, 40 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Wednesday, September 07, 2011 9:51:17 AM GMT
Hi all , First a fall if you are rally interested in Active-X script task then only read this article ,Because it has not been use now a days !! Its has been used in 2000 its decade now still I feel like having post on same. All we use is script... (more)
category: Data | clicked: 8 | 1 comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSIS
5
Shouts
spam Shout it Mute it

Over clause enhancement in Sql 11 Denali CTP 3
published 650 days, 19 hours, 20 minutes ago posted by kinj312kinj312 652 days, 16 hours, 8 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:23:30 AM GMT
In Denali CTP 3, the Over clause has been enhanced a lot. Let us look into them as below a.Rows and Range These keywords specifies that the function will be applied for every row a window use for calculating the function result. The Rows specifies the... (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, denali, CTP
6
Shouts
spam Shout it Mute it

SSIS #100 – An SSIS package without Sequence Container?
published 650 days, 19 hours, 20 minutes ago posted by kinj312kinj312 652 days, 16 hours, 9 minutes ago
Thursday, September 08, 2011 7:11:32 AM GMT Tuesday, September 06, 2011 10:22:23 AM GMT
I recently needed to modify an SSIS package to add a few new columns to a table. But I turned out that I had more than just adding columns to do. I did three things prior to adding the columns: I added three Sequence Containers as part of the Control... (more)
category: Data | clicked: 2 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
6
Shouts
spam Shout it Mute it

New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3
published 652 days, 20 hours, 5 minutes ago posted by dharadhara 653 days, 18 hours, 48 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:43:01 AM GMT
New expression language functions(Left,Token,TokenCount) in SSIS Denali CTP 3 In Denali CTP 3, we have three new functions in the expression language viz. Left , Token and TokenCount so far SSIS is concern Let us analyze these functions one by one Left... (more)
category: Data | clicked: 9 | 6 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, CTP
6
Shouts
spam Shout it Mute it

SSIS #98 – IsSorted is true, but sorted on what?
published 652 days, 20 hours, 5 minutes ago posted by dharadhara 653 days, 18 hours, 49 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:36 AM GMT
In my previous post, SSIS #97 – When MERGE JOIN is your friend? , I showed you a scenario where Merge Join can be you real friend in your ETL work. I also showed you two ways to satisfy the sorting requirement by the Merge Join task. One of the... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, SSIS, BI
6
Shouts
spam Shout it Mute it

Index Disabled and Index Rebuild
published 652 days, 20 hours, 5 minutes ago posted by dharadhara 653 days, 18 hours, 49 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Monday, September 05, 2011 7:42:10 AM GMT
I received the following message from a Developer. The message was on a Test SQL Server. “NC_myIndex " on table "VeryLargeTable" (specified in the FROM clause) is disabled or resides in a filegroup which is not online . The cause... (more)
category: Data | clicked: 36 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

SQL Server 2008 Service Pack 3 CTP is available for testing!
published 652 days, 20 hours, 5 minutes ago posted by kinj312kinj312 655 days, 17 hours, 30 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:53 AM GMT
There is no doubt that Microsoft is keeping the DBAs busy with the frequent releases of Cumulative Update packages and CTP releases on existing (2008, 2008 R2 and Denali) versions! Now here is the news about SQL Server 2008 Service Pack 3 CTP release... (more)
category: Data | clicked: 8 | 3 comments | | source: beyondrelational.com
tags: SQL Server, CTP
7
Shouts
spam Shout it Mute it

Correctness and stress test
published 652 days, 20 hours, 5 minutes ago posted by kinj312kinj312 655 days, 17 hours, 31 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 9:00:17 AM GMT
Stress test SQL Server for new hardware. Download SQLIOSim from http://download.microsoft.com and install on server. When detailing the file location, use the same as the SQL Server files. SQLIOSim will attempt to simulate the SQL Server database IO path... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

SQL Server Configuration Manager - Hide your SQL Server Instance
published 652 days, 20 hours, 5 minutes ago posted by kinj312kinj312 655 days, 17 hours, 31 minutes ago
Tuesday, September 06, 2011 6:26:05 AM GMT Saturday, September 03, 2011 8:59:50 AM GMT
Data is one of the most critical and valuable components for any industry and it’s protection is every individual’s responsibility. Data lives within Microsoft SQL Server, and therefore, it is the duty of DBAs to ensure that their SQL Server is safe from... (more)
category: Data | clicked: 5 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

TSQL Challenge 63 - A TSQL Sudoku
published 655 days, 16 hours, 10 minutes ago posted by dharadhara 656 days, 14 hours, 39 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:52:32 AM GMT
This challenge is a puzzle of numbers. Everyone of you might have came across this puzzle named 'Sudoku'. (more)
category: Data | clicked: 11 | 3 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
6
Shouts
spam Shout it Mute it

Define IOPs for all database servers
published 655 days, 16 hours, 10 minutes ago posted by dharadhara 656 days, 14 hours, 40 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:51:30 AM GMT
The storage guy is configuring a new storage system. It includes RAID arrays, SVC, HBA & Fibre Channel configurations. He’s asked me to define some configurations for optimal SQL Server performance. Rather than supply him with configurations... (more)
category: Data | clicked: 7 | 5 comments | | source: beyondrelational.com
tags: SQL Server, Database
5
Shouts
spam Shout it Mute it

c# and .NET interview questions :- What is the use of "VAR" keyword in .NET and c# ?
published 655 days, 16 hours, 10 minutes ago posted by questpondquestpond 656 days, 14 hours, 41 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Friday, September 02, 2011 11:50:17 AM GMT
Many .NET developers are confused about what is the use of VAR keyword. In this video we will first understand what exactly is this new keyword VAR and then we see 2 important uses of VAR keyword in .NET. .NET and C# interview questions (more)
category: Web Dev | clicked: 16 | 1 comment | | source: youtu.be
tags: SQL Server, WCF Interview Questions, .Net Interview Questions, Asp.net interview questions, C# interview Questions
9
Shouts
spam Shout it Mute it

MSBI # 23 – SSIS # 10 – Control Flow Tasks # 5 – For Each Loop Container Task
published 655 days, 16 hours, 10 minutes ago posted by kinj312kinj312 658 days, 18 hours, 35 minutes ago
Saturday, September 03, 2011 10:20:57 AM GMT Wednesday, August 31, 2011 7:56:46 AM GMT
Continuing from my last post on SSIS Control flow task in which we talk lot about For Loop Container: MSBI # 22 – SSIS # 9 – Control Flow Tasks # 4 – For Loop Container Task « (B)usiness (I)ntelligence Mentalist We are covering following points in this... (more)
category: Data | clicked: 10 | 3 comments | | source: beyondrelational.com
tags: SQL Server, MSBI, BI
Previous 1 2 ... 12 13 14 15 16 17 18 19 20 21 ... 43 44 Next