DotNetShoutout - Stories tagged with TSQL

TSQL

atom rss
5
Shouts
spam Shout it Mute it

Get random row from the table
published 467 days, 19 hours, 32 minutes ago posted by dharadhara 471 days, 2 hours, 38 minutes ago
Thursday, March 08, 2012 9:17:15 PM GMT Monday, March 05, 2012 2:10:43 PM GMT
Sometimes it happens that we need random row (or set of randoms rows) from table. Itzik Ben-Gan shows us, in one of his book, the efficient way to do this: (more)
category: Data | clicked: 29 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

#0138 - SQL Server – Performance – Best Practice – Create Index Before or After a data insert – I/O, Fragmentation, CPU and Elapsed time comparison - Test results
published 467 days, 19 hours, 32 minutes ago posted by dharadhara 474 days, 22 hours, 18 minutes ago
Thursday, March 08, 2012 9:17:15 PM GMT Thursday, March 01, 2012 6:30:24 PM GMT
In November 2011, I wrote a post titled SQL Server – Performance – Best Practice – Create Index Before or After a data insert? . The post dealt with answering the question - which method was better – whether to create an index before or after a bulk-insert... (more)
category: Data | clicked: 111 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

Review: OfficeWriter v8
published 468 days, 6 hours, 14 minutes ago posted by dharadhara 475 days, 22 hours, 3 minutes ago
Thursday, March 08, 2012 10:35:16 AM GMT Wednesday, February 29, 2012 6:46:14 PM GMT
As a BI consultant specializing in SSRS, I have had lots of frustrations and hard times because of Excel. Every now and then, I have some or other business user coming up to me and asking for some feature which is there in Excel but not in SSRS. If you... (more)
category: Data | clicked: 20 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, BI
7
Shouts
spam Shout it Mute it

You can drop multiple tables using single DROP statement
published 468 days, 6 hours, 14 minutes ago posted by dharadhara 476 days, 23 hours, 7 minutes ago
Thursday, March 08, 2012 10:35:16 AM GMT Tuesday, February 28, 2012 5:42:02 PM GMT
Suppose you have three tables named test1,test2 and test3 and you want to drop all these three, you can do it in a single DROP statement (more)
category: Data | clicked: 42 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL
7
Shouts
spam Shout it Mute it

Read contents of a file to variable – SSIS
published 467 days, 19 hours, 32 minutes ago posted by dharadhara 476 days, 23 hours, 7 minutes ago
Thursday, March 08, 2012 9:17:15 PM GMT Tuesday, February 28, 2012 5:41:25 PM GMT
Sometimes you will find the need to import a file to a variable using SSIS. In this post, I’ll use Script Task to read contents of a flat file into a variable. (more)
category: Data | clicked: 45 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS, BI
5
Shouts
spam Shout it Mute it

TSQL Challenge 76 - Identify the sequence of accounting transactions
published 468 days, 13 hours, 14 minutes ago posted by dharadhara 477 days, 22 hours, 14 minutes ago
Thursday, March 08, 2012 3:35:17 AM GMT Monday, February 27, 2012 6:34:29 PM GMT
The challenge is to identify the sequence of accounting transactions. The table has data which is ordered. You need to follow the order of the data, and detect a certain condition which lasts for a sequence of data rows, you need to give these data points an ID which uniquely identifies the sequence. T (more)
category: Data | clicked: 67 | 2 comments | | source: beyondrelational.com
tags: SQL Server, tsql challenges, TSQL
4
Shouts
spam Shout it Mute it

Fun with Square braces
published 468 days, 6 hours, 14 minutes ago posted by dharadhara 477 days, 22 hours, 15 minutes ago
Thursday, March 08, 2012 10:35:16 AM GMT Monday, February 27, 2012 6:33:27 PM GMT
Square braces in SQL Server play a major role in T-SQL programming. When an object name contains a space, special character, etc, the only way to express them is to put them aroud squre braces. Consider that you want to create a table user master (with... (more)
category: Data | clicked: 31 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
3
Shouts
spam Shout it Mute it

#0135 - SQL Server – SSMS – Tutorial – 10 - Troubleshooting (L200)
published 478 days, 7 hours, 1 minute ago posted by kinj312kinj312 487 days, 22 hours, 10 minutes ago
Monday, February 27, 2012 9:47:43 AM GMT Friday, February 17, 2012 6:39:02 PM GMT
All systems are susceptible to failure. No software is perfect, and therefore it is natural that SSMS too will fail. Today, I have put together some of the most common failures that I have experienced with SSMS and their known workarounds. The reason... (more)
category: Data | clicked: 52 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
5
Shouts
spam Shout it Mute it

#0134 - SQL Server – SSMS – Tutorial – 09 - Integrating with peripheral services & other SQL Server tools (L200)
published 487 days, 20 hours, 16 minutes ago posted by dharadhara 490 days, 14 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Wednesday, February 15, 2012 4:34:47 PM GMT
As mentioned in Part 01 of this tutorial series, one of the key responsibilities of SSMS was to replace the erstwhile SQL Server Enterprise Manager – the interface that is used to manage & maintain the SQL Server instance configuration. In addition... (more)
category: Data | clicked: 32 | comment | | source: beyondrelational.com
tags: SQL Server, ssms, TSQL
6
Shouts
spam Shout it Mute it

SSIS - Delete files older than retention period from folder with parameter using Script Task in SQL Server
published 487 days, 20 hours, 16 minutes ago posted by dharadhara 490 days, 15 minutes ago
Friday, February 17, 2012 8:33:18 PM GMT Wednesday, February 15, 2012 4:34:20 PM GMT
After using some of the ways to delete the files from the particular folder like Delete file using Script Task and File System Task in SSIS. We have seen such methods and used logic to get the files from the loop container and process to delete them and... (more)
category: Data | clicked: 32 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Jeff Wharton's Blog - SQL Server Integration Services 2012 (RC0) Project Conversion Bugs
published 489 days, 2 hours, 35 minutes ago posted by dharadhara 490 days, 23 hours, 33 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:15:37 PM GMT
UPDATE – 10th February 2012 Since writing this article I’ve discovered that the Int32 error discussed below occurs irrespective of whether the ServerPort value is greater than 32767 i.e. even a value of 21 (the default) causes the same error. I’ve also... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

#0133 - SQL Server – SSMS – Tutorial – 08 - How SSMS helps in reviewing and configuring your SQL Server Instance (L200)
published 489 days, 2 hours, 35 minutes ago posted by dharadhara 490 days, 23 hours, 34 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:14:59 PM GMT
One of the most important aspects of SQL Server administration and maintenance is the ability to review and changing the existing configuration of the server. In Part 01 of this tutorial series, I had mentioned that one of the key responsibilities of... (more)
category: Data | clicked: 19 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
6
Shouts
spam Shout it Mute it

SSIS Tutorial - Getting started with SSIS - Part 4: Control Flow - Sudeep Raj
published 489 days, 2 hours, 35 minutes ago posted by dharadhara 490 days, 23 hours, 34 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Tuesday, February 14, 2012 5:14:39 PM GMT
In Control Flow, we set up the flow of jobs in an ETL process, like fetching the files from ftp location to local and then make the file ready for ETL or at times, we clear the staging tables before the ETL process. All such tasks are done before ETL commences. (more)
category: Data | clicked: 27 | 2 comments | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
5
Shouts
spam Shout it Mute it

Question of the month February 2012 - Find out problamatic query
published 489 days, 2 hours, 35 minutes ago posted by dharadhara 491 days, 22 hours, 51 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Monday, February 13, 2012 5:57:52 PM GMT
Without running these queries can you find out the query that would throw an error? (more)
category: Data | clicked: 27 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

#0132 - SQL Server – SSMS – Tutorial – Part 07 - Database Administration and maintenance - Productivity enhancing features (L200)
published 489 days, 2 hours, 35 minutes ago posted by dharadhara 491 days, 22 hours, 52 minutes ago
Thursday, February 16, 2012 2:14:19 PM GMT Monday, February 13, 2012 5:56:51 PM GMT
The SQL Server Management studio contains many pop-up utilities and tools that help in improving the productivity of our day-to-day database administration and maintenance tasks. While most of these would be implemented using T-SQL code in production... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
3
Shouts
spam Shout it Mute it

SQL Server 2012 Virtual Labs
published 489 days, 10 hours, 18 minutes ago posted by dharadhara 494 days, 21 hours, 59 minutes ago
Thursday, February 16, 2012 6:31:00 AM GMT Friday, February 10, 2012 6:50:00 PM GMT
Want to play around with SQL Server 2012 but don’t have an environment to play around in? Check out the following SQL Server 2012 Virtual Labs: (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
5
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 3: First SSIS Package - Sudeep Raj
published 493 days, 23 hours, 59 minutes ago posted by kinj312kinj312 495 days, 22 hours, 22 minutes ago
Saturday, February 11, 2012 4:49:46 PM GMT Thursday, February 09, 2012 6:26:43 PM GMT
Hope that you have a basic understanding of ETL, SSIS and BIDS. So without much delay, let us start getting our package to move data from a flat file to a database table. The table does not exist and needs to be created while development. (more)
category: Data | clicked: 44 | 1 comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
5
Shouts
spam Shout it Mute it

Set the Slice on your SSAS Cube Partitions now!
published 494 days, 23 hours, 49 minutes ago posted by kinj312kinj312 497 days, 23 hours, 20 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:28:32 PM GMT
I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
7
Shouts
spam Shout it Mute it

Getting started with SSIS - Getting started with SSIS - Part 2: BIDS Overview - Sudeep Raj
published 495 days, 18 hours, 33 minutes ago posted by kinj312kinj312 497 days, 23 hours, 21 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Tuesday, February 07, 2012 5:28:05 PM GMT
What is BIDS? Why do I need it? Where can I find it? 3 questions are asked here. Therefore, I will provide the 3 answers to you. (more)
category: Data | clicked: 23 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL, SSIS
7
Shouts
spam Shout it Mute it

Identity column with decimal datatype
published 495 days, 18 hours, 33 minutes ago posted by dharadhara 498 days, 20 hours, 37 minutes ago
Thursday, February 09, 2012 10:15:54 PM GMT Monday, February 06, 2012 8:12:20 PM GMT
One of the members in the forum asked about using decimal datatype in identity column. The question was "Is decimal point allowed in the identity column?" Ok. The identity column can never have any decimal points. It is a whole number. The decimal... (more)
category: Data | clicked: 9 | comment | | source: beyondrelational.com
tags: SQL Server, TSQL
Previous 1 2 3 4 5 6 7 8 9 10 ... 28 29 Next