DotNetShoutout - Stories tagged with SQL

SQL

atom rss
2
Shouts
spam Shout it Mute it

SQL Server Activity Monitor Tool for Database Administrators
published 465 days, 7 hours, 33 minutes ago posted by eralpereralper 465 days, 13 hours, 50 minutes ago
Tuesday, February 14, 2012 12:48:59 PM GMT Tuesday, February 14, 2012 6:32:26 AM GMT
SQL Server Activity Monitor is a new SQL Server tool for database administrators to control and troubleshoot SQL Server performance issues. SQL Server Activity Monitor tool combines a list of SQL Server performance data and serves collected performance data from various points with a graphical display to database administrators as a new SQL Server monitoring tool (more)
category: Data | clicked: 15 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL Server 2008, SQL
3
Shouts
spam Shout it Mute it

SQL Server BCP Utility with sp_HelpText to Generate Script File for Each Stored Procedure in a Database
published 466 days, 18 minutes ago posted by eralpereralper 469 days, 5 hours, 9 minutes ago
Monday, February 13, 2012 8:04:31 PM GMT Friday, February 10, 2012 3:12:42 PM GMT
SQL Server BCP utility is used to write sql query results to text files into a file folder. If T-SQL developers use SQL BCP with sp_HelpText, it is possible to generate script files for SQL Server objects too. (more)
category: Data | clicked: 20 | comment | | source: www.kodyaz.com
tags: SQL Server, BCP, SQL, T-SQL
5
Shouts
spam Shout it Mute it

SQL Server 2012 Developer Training Kit BOM
published 468 days, 3 hours, 32 minutes ago posted by kinj312kinj312 471 days, 55 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Wednesday, February 08, 2012 7:27:15 PM GMT
The SQL Server 2012 Early Adoption Team has put together some great resources to assist developers with skilling up on SQL Server 2012; one of which is the SQL Server 2012 Developer Training Kit BOM wiki. The wiki, which is based on the SQL Server 2012... (more)
category: Data | clicked: 22 | comment | | source: beyondrelational.com
tags: SQL, sql server 2012
2
Shouts
spam Shout it Mute it

List Month Names using SQL Functions
published 469 days, 3 hours, 22 minutes ago posted by eralpereralper 472 days, 5 hours, 18 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 3:04:13 PM GMT
List Month Names using SQL Functions SQL developers may need to list month names using SQL functions during their T-SQL programming tasks. This Transact-SQL tutorial will demonstrate sql codes with DATENAME() function that ca... (more)
category: Data | clicked: 9 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, T-SQL
2
Shouts
spam Shout it Mute it

Split Backup in SQL Server into Multiple Files
published 469 days, 3 hours, 22 minutes ago posted by eralpereralper 472 days, 5 hours, 19 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 3:02:54 PM GMT
Split Backup in SQL Server into Multiple Files In order to split backup in SQL Server into multiple files, database administrators can use T-SQL Backup Database command as well as SQL Server Management Studio Back up Database Ta... (more)
category: Data | clicked: 10 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, backup
3
Shouts
spam Shout it Mute it

SQL Server interview questions: – Mention Fragmentation in SQL Server? | dotnetinterviewquestion
published 480 days, 11 hours, 40 minutes ago posted by questpondquestpond 485 days, 8 hours, 12 minutes ago
Monday, January 30, 2012 8:42:23 AM GMT Wednesday, January 25, 2012 12:10:27 PM GMT
In this article we will explain about Fragmantation in SQL Server. For articles and videos visit us on http://www.questpond.com/ (more)
category: Data | clicked: 18 | comment | | source: dotnetinterviewquestion.wordpress.com
tags: .NET, SQL Server Interview Questions, data, SQL, .Net Interivew Questions, fragmentation
3
Shouts
spam Shout it Mute it

SQL Server interview questions: – Can you mention two types of indexes and explain them?
published 481 days, 21 hours, 18 minutes ago posted by questpondquestpond 491 days, 8 hours, 13 minutes ago
Saturday, January 28, 2012 11:04:38 PM GMT Thursday, January 19, 2012 12:09:21 PM GMT
In this article we will explain about Clustered index and Non-Clustered Index. For more articles and videos visit us on http://www.questpond.com (more)
category: Data | clicked: 21 | comment | | source: dotnetinterviewquestion.wordpress.com
tags: .NET, SQL server interview questions, .Net Interview Questions, SQL, Clustered
2
Shouts
spam Shout it Mute it

SQL Server interview questions: - Define publisher, distributor and subscriber in “Replication”?
published 515 days, 12 hours, 7 minutes ago posted by questpondquestpond 517 days, 9 hours, 13 minutes ago
Monday, December 26, 2011 8:15:27 AM GMT Saturday, December 24, 2011 11:08:46 AM GMT
In this article we will explain publisher, distributor and subscriber in “Replication”. For more articles and videos visit us on www.questpond.com (more)
category: Data | clicked: 7 | comment | | source: www.xpode.com
tags: Subscriber, SQL Server, publisher, SQL, distributor
3
Shouts
spam Shout it Mute it

SQL Server interview questions: - How many types of relationship exist in database designing?
posted by questpondquestpond 519 days, 7 hours, 6 minutes ago
Thursday, December 22, 2011 1:15:43 PM GMT
In this aricle we will explain different types of relationship existing in database designing.For more articles and videos visit us on www.questpond.com (more)
category: Data | clicked: 11 | comment | | source: dotnetinter.livejournal.com
tags: .NET, .Net Interview Questions, SQL, Asp.net interview questions, ASP.NET
2
Shouts
spam Shout it Mute it

Building Ranges using T-SQL - SQL Server Performance
posted by JudoJudo 597 days, 7 hours, 1 minute ago
Wednesday, October 05, 2011 1:21:09 PM GMT
We often use excel for any running repetitive calculations since it is a very convenient user friendly interface which allows us to just enter a formula in a cell and  simply  drag and drop the  formulas to generate a complete output. For example, I had a Products listing, with ID and Quantity for each product. In this example, MinID and MaxId are the minimum and maximum id range of a given product quantity. Say we have a quantity of 50 for Product A then we will need to set the MinId as 1 and MaxID as ... (more)
category: Data | clicked: 1 | comment | | source: www.sql-server-performance.com
| flag as spam
tags: SQL Server, ranges, TSQL, SQL
2
Shouts
spam Shout it Mute it

SQL Server interview questions: - Tell us about ACID fundamental? What are transactions in SQL SERVER? |
published 634 days, 1 hour, 24 minutes ago posted by questpondquestpond 634 days, 6 hours, 47 minutes ago
Monday, August 29, 2011 6:57:44 PM GMT Monday, August 29, 2011 1:35:22 PM GMT
A transaction is a sequence of operations performed as a single logical unitof work. A logical unit of work must exhibit four properties, called the ACID (more)
category: Data | clicked: 6 | comment | | source: questpond.blog.com
tags: SQL Server, SQL
2
Shouts
spam Shout it Mute it

SQL-Articles » Steps to configure SQL server Availability Groups in DENALI
posted by sqlarticlessqlarticles 645 days, 2 hours, 18 minutes ago
Thursday, August 18, 2011 6:04:19 PM GMT
In this blog post I will drive you through configurations steps required (with GUI screens) to successfully implement SQL server’s new high availability option called “ALWAYSON” aka HADR . If you haven’t read more about Always ON or Availability groups in SQL server code named “Denali” version, here are some articles that I would recommend you read before using this blog post to configure SQL server’s new and cool feature........ (more)
category: Data | clicked: 1 | comment | | source: sql-articles.com
tags: high availability, always on, hadr, SQL, denali, sqlarticles, sql 2011
3
Shouts
spam Shout it Mute it

Overcoming SQL 08’s globally insensitive time zones using .NET
published 650 days, 23 hours, 2 minutes ago posted by http://troyhunt.myopenid.com/http://troyhunt.myopenid.com/ 653 days, 9 hours, 19 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Wednesday, August 10, 2011 11:03:31 AM GMT
When SQL 08 came along there seemed to be some new hope for making time zone aware apps a little easier through the introduction of a few new date and time related data types, particularly the datetimeoffset type. Unfortunately all that glitters is not gold in this case and the new data type can be a real “gotcha”. Here’s how to build in that geo-awareness from the ground up using the new datetime2 data type and without getting caught with your metaphorical pants down. (more)
category: Web Dev | clicked: 11 | comment | | source: www.troyhunt.com
tags: .NET, SQL
12
Shouts
spam Shout it Mute it

Many to Many Relationship Made Simpler
published 650 days, 23 hours, 2 minutes ago posted by pinaldavepinaldave 655 days, 10 hours, 29 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Monday, August 08, 2011 9:53:27 AM GMT
We need a new process to map this complex relationship. Sometimes tables exist for the sole purpose of allowing indirect relationships between tables. What do you call tables the handle relationships for other tables? Common terms for these type of tables are mapping tables, bridge tables, or junction tables. Learn about Many to many relationship and Win Free Book (more)
category: Data | clicked: 62 | 2 comments | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
2
Shouts
spam Shout it Mute it

SQL UPDATE statement with SELECT and SQL Server Image data type column
published 655 days, 23 hours, 42 minutes ago posted by lenielleniel 657 days, 3 hours, 14 minutes ago
Sunday, August 07, 2011 8:39:59 PM GMT Saturday, August 06, 2011 5:08:01 PM GMT
In a SQL Server database I have a table called users which has a column named signature. This columns is of type Image. My production SQL Server is located in a shared hosting environment. One problem I’ve been facing lately is that I need permission to execute an UPDATE statement to insert a signature image for a given user. This problem occurs because to insert a signature image for a given user I have to execute a BULK statement. Read on... (more)
category: Data | clicked: 17 | comment | | source: www.leniel.net
tags: SQL Server, Bulk, Update, ssms, select, data, SQL, image, Microsoft, Database, linked server
11
Shouts
spam Shout it Mute it

Learning SQL Server - Efficient Query Writing Strategy - Gift Book
published 650 days, 23 hours, 2 minutes ago posted by pinaldavepinaldave 659 days, 2 hours, 36 minutes ago
Friday, August 12, 2011 9:20:11 PM GMT Thursday, August 04, 2011 5:45:47 PM GMT
Some people may push back on this next technique or misunderstand until getting to the very end. The goal is to have fewer errors as you write complex queries more quickly by making sure the easy stuff works first. (more)
category: Data | clicked: 56 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
10
Shouts
spam Shout it Mute it

Find Nth Record Quickest Way in SQL Server
published 663 days, 30 minutes ago posted by pinaldavepinaldave 667 days, 24 minutes ago
Sunday, July 31, 2011 7:52:05 PM GMT Wednesday, July 27, 2011 7:58:14 PM GMT
A Very simple tutorial to find Nth Record (more)
category: Data | clicked: 47 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
5
Shouts
spam Shout it Mute it

Arabic Series in Microsoft SQL Server– Part2 Database Infrastructure « Technical tips around you
posted by https://me.yahoo.com/mosessaur#7fe0dhttps://me.yahoo.com/mosessaur#7fe0d 678 days, 19 hours, 5 minutes ago
Saturday, July 16, 2011 1:17:37 AM GMT
Arabic Series in Microsoft SQL Server– Part2 Database Infrastructure (more)
category: Data | clicked: 6 | comment | | source: ahmedmosa.wordpress.com
tags: SQL Server 2008, SQL, SQLServer
12
Shouts
spam Shout it Mute it

SQL SERVER – Database Worst Practices – New Town and New Job and New Disasters « Journey to SQLAuthority
published 679 days, 9 hours, 17 minutes ago posted by pinaldavepinaldave 682 days, 7 hours, 10 minutes ago
Friday, July 15, 2011 11:05:20 AM GMT Tuesday, July 12, 2011 1:11:59 PM GMT
Instead of writing best practices, I am going to write about few of the worst practices which I have quite often seen in the real world. Some of them are really bad that I often wonder how those who still use them were able to continue on the job so far. Let us go over few of the worst practices I have observed in the industry. (more)
category: Data | clicked: 118 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
9
Shouts
spam Shout it Mute it

Two Simple Puzzles - Tease Your Brain - Win Knowledge and Gift
published 690 days, 12 hours, 8 minutes ago posted by pinaldavepinaldave 694 days, 14 hours, 35 minutes ago
Monday, July 04, 2011 8:14:28 AM GMT Thursday, June 30, 2011 5:47:03 AM GMT
Today I have two simple T-SQL Puzzle. You can answer them and win USD 25 Gift card. The gift card will be sent in email to winner. You will get choice of Gift Card brand based on your preference and country location. (more)
category: Data | clicked: 24 | comment | | source: blog.sqlauthority.com
tags: SQL, SQLServer, pinaldave, SQLAuthority
Previous 1 2 3 4 5 6 7 8 9 10 Next