Ms Sql Server Technology Discussions

[mtkr]

[lolliman]

good going guys and gals

[deals2buy]

[quote name='lolliman' timestamp='1357322492' post='1303053689']
good going guys and[b][color=#ff0000] gals[/color][/b]
[/quote]
enti vaallu kuda unnaara ee thaadu lo? [img]http://lh3.ggpht.com/--o7mXz3u-j4/T9VVBGzBJAI/AAAAAAAAGo0/kmj8a1-XW2g/s150/PK-1.gif[/img]

[mtkr]

Oracle(SQL navigator) lo oka table ni ela script chesthharuu???


like t-sql(management studio) lo aithe tbl meeda rt-clk chesi script tbl as--- crte to-- new window / file

ala oracle lo ela chesthaaruuu??

[deals2buy]

[quote name='mtkr' timestamp='1357337368' post='1303055574']
Oracle(SQL navigator) lo oka table ni ela script chesthharuu???


like t-sql(management studio) lo aithe tbl meeda rt-clk chesi script tbl as--- crte to-- new window / file

ala oracle lo ela chesthaaruuu??
[/quote]

[deals2buy]

[b] Using SSMS Commandline Parameters[/b]


Using SQL Server Management Studio is something we do instantly after connecting to our mailing system everyday if we are a SQL Developer or SQL Administrator. Though this is a very common step, there can be optimizations we can make even in this mundane yet simple task. Let us look at the steps we take normally.[list]
[*]We find the “SQL Server Management Studio” icon from the start menu and will click on it.
[list=1]
[*]We can also type “ssms” in the run prompt to quickly launch. This is my favorite and I use almost daily.
[*]After Management Studio launches we need to give the Authentication mode. Let us assume we use Windows Authentication and we press “Enter” to login.
[*]This initializes the Object Explorer with the Login.
[*]Right click on Database or Server node to open a query window.
[/list]
[/list]
As we can see that even though this is a common activity has taken close to 4-5 clicks. How about making this efficient? If you didn’t know we have some hidden command line parameters available with SQL Server Management Studio. To know the parameters, from the run prompt just for this command.
[img]http://www.pinaldave.com/bimg/ssmsshortcut.jpg[/img]
C:\> [b]ssms /?[/b]
This brings the list of parameters we can use. The figure below shows the same.
To tabulate the various options: [b]Command Line Switch[/b] [b]Description[/b] [b]S[/b] The name of the SQL Server instance to connect to. [b]d[/b] The name of the SQL Server database to connect to. [b]U[/b] The name of the SQL Server login to connect with. [b]P[/b] The password associated with the login. [b]E[/b] Use Windows Authentication to login to SQL Server. [b]noSplash[/b] Suppress splash screen. [b]? [/b] Displays this usage information. [b]file_name[/b] File to load upon startup. Good for loading a .SQL file directly.
Having known all the parameters, here is the tip we would like to give you. Fire Management Studio using the authentication in one shot using the following command.
C:\> [b]ssms -E[/b]
In this case we have used the Windows Authentication to login. We can replace the same with –U and –P parameters for SQL Authentication. Feel free to use the –d option to connect to a specific database.
Another tip, if you want to change the default behavior of the shortcut, then right click the shortcut and select properties. Add the –E or other appropriate options to your desire.
[img]http://www.pinaldave.com/bimg/ssmsshortcut1.png[/img]

After adding the option. Click the “Ok” button. Now when we fire the Management Studio icon, this will open the management studio with an active Query window ready to do the work.

[deals2buy]

[b] Using the Script Task in SSIS to Process Data Files When They Arrive[/b]



http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/91665/

[deals2buy]

[b] Partitioning in SQL Server[/b]



http://www.databasejournal.com/features/mssql/partitioning-in-sql-server-part-2.html

[deals2buy]

[b]
[url="http://www.sqlservercentral.com/blogs/robert_davis/2013/01/06/day-5-of-31-days-of-disaster-recovery-dealing-with-corruption-in-a-nonclustered-index/"]Dealing With Corruption in a Nonclustered Index[/url][/b]

[deals2buy]

Here are some declarations:
set nocount on
declare @i int, @n numeric(10,4), @d datetime, @v varchar(12);
These declarations are followed by a single select statement in the same batch; the declarations work, but the select statement fails. Which of the following statements could be the failing select statement? (choose 3)

[deals2buy]

[b] SQL Server Rounding Functions - Round, Ceiling and Floor[/b]


http://www.mssqltips.com/sqlservertip/1589/sql-server-rounding-functions--round-ceiling-and-floor/

[gundugadu]

[quote name='Kaarthikeya' timestamp='1357653371' post='1303070747']
[b] Using the Script Task in SSIS to Process Data Files When They Arrive[/b]



[url="http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/91665/"]http://www.sqlserver...s (SSIS)/91665/[/url]


[/quote][quote name='Kaarthikeya' timestamp='1357738396' post='1303077581']
[b] SQL Server Rounding Functions - Round, Ceiling and Floor[/b]


[url="http://www.mssqltips.com/sqlservertip/1589/sql-server-rounding-functions--round-ceiling-and-floor/"]http://www.mssqltips...ling-and-floor/[/url]


[/quote]
[quote name='Kaarthikeya' timestamp='1357653206' post='1303070741']
[b] Using SSMS Commandline Parameters[/b]


Using SQL Server Management Studio is something we do instantly after connecting to our mailing system everyday if we are a SQL Developer or SQL Administrator. Though this is a very common step, there can be optimizations we can make even in this mundane yet simple task. Let us look at the steps we take normally.[list]
[*]We find the “SQL Server Management Studio” icon from the start menu and will click on it.
[list=1]
[*]We can also type “ssms” in the run prompt to quickly launch. This is my favorite and I use almost daily.
[*]After Management Studio launches we need to give the Authentication mode. Let us assume we use Windows Authentication and we press “Enter” to login.
[*]This initializes the Object Explorer with the Login.
[*]Right click on Database or Server node to open a query window.
[/list]
[/list]
As we can see that even though this is a common activity has taken close to 4-5 clicks. How about making this efficient? If you didn’t know we have some hidden command line parameters available with SQL Server Management Studio. To know the parameters, from the run prompt just for this command.
[img]http://www.pinaldave.com/bimg/ssmsshortcut.jpg[/img]
C:\> [b]ssms /?[/b]
This brings the list of parameters we can use. The figure below shows the same.
To tabulate the various options: [b]Command Line Switch[/b] [b]Description[/b] [b]S[/b] The name of the SQL Server instance to connect to. [b]d[/b] The name of the SQL Server database to connect to. [b]U[/b] The name of the SQL Server login to connect with. [b]P[/b] The password associated with the login. [b]E[/b] Use Windows Authentication to login to SQL Server. [b]noSplash[/b] Suppress splash screen. [b]? [/b] Displays this usage information. [b]file_name[/b] File to load upon startup. Good for loading a .SQL file directly.
Having known all the parameters, here is the tip we would like to give you. Fire Management Studio using the authentication in one shot using the following command.
C:\> [b]ssms -E[/b]
In this case we have used the Windows Authentication to login. We can replace the same with –U and –P parameters for SQL Authentication. Feel free to use the –d option to connect to a specific database.
Another tip, if you want to change the default behavior of the shortcut, then right click the shortcut and select properties. Add the –E or other appropriate options to your desire.
[img]http://www.pinaldave.com/bimg/ssmsshortcut1.png[/img]

After adding the option. Click the “Ok” button. Now when we fire the Management Studio icon, this will open the management studio with an active Query window ready to do the work.
[/quote]


baaaaa nuvvu super baaaaaaaa

aaa script compponent post matram adurs
!~>( !~>(
nuvvu developer leka DBA na

[Darling999]

[b] SSIS Component Samples List[/b]
[color=#333333][font=Arial, Tahoma, Verdana][size=3]
This is a directory of all the SSIS Components with links to the introductory articles and samples I have created to help understand them. If no link exists it means the article hasn’t been written yet! If you want to hurry me along on one component that I haven’t done, please leave a request in the comments.[/size][/font][/color]
[b] SSIS Control Flow and Data Flow Items with Examples[/b]



[b] http://www.bimonkey.com/support/ssis-component-samples-list/[/b]



[b] Data Flow[/b]

[b] Data Flow Sources[/b]
[color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]ADO .NET / DataReader Source[/b] – [url="http://www.bimonkey.com/2009/05/the-ado-net-source-and-sql-in-the-script-task/"]Article[/url] – Samples: 2005 – [url="http://www.bimonkey.com/uploads/componentreview/ADO%20NET%20Source%20Component%20Basics.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Excel Source[/b] – [url="http://www.bimonkey.com/2009/05/the-excel-source-and-connection-manager-the-basics/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/excelsource2005.zip"]2005[/url] – [url="http://www.bimonkey.com/uploads/componentreview/excelsource2008.zip"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b][url="http://www.bimonkey.com/support/ssis-component-samples-list/#"]Flat File[/url] Source[/b] – [url="http://www.bimonkey.com/2009/05/the-flat-file-connection-manager-and-source/"]Article[/url] – Samples: 2005 - [url="http://www.bimonkey.com/uploads/componentreview/flatfilesource.zip"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]OLE DB Source[/b] – [url="http://www.bimonkey.com/2009/04/the-ole-db-source-component-the-basics/"]Article[/url] – Samples: 2005 – [url="http://www.bimonkey.com/uploads/componentreview/OLEDB%20Source%20Component%20Basics.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Raw File Source[/b] – [url="http://www.bimonkey.com/2009/04/the-raw-file-source-and-destination/"]Article[/url] – Samples: 2005 – [url="http://www.bimonkey.com/uploads/componentreview/Raw%20File%20Components%20Basics.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]XML Source[/b] – [url="http://www.bimonkey.com/2009/04/the-xml-source-component-the-basics/"]Article[/url] – Samples: 2005 – [url="http://www.bimonkey.com/uploads/componentreview/XMLSource.zip"]2008[/url][/size][/font][/color]
[b] Data Flow Transformations[/b]
[color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Aggregate[/b] – [url="http://www.bimonkey.com/2009/05/the-aggregate-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Aggregate%20Transformation%20Basics%202005.dtsx"]2005[/url] – [url="http://www.bimonkey.com/uploads/componentreview/Aggregate%20Transformation%20Basics%202008.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Audit[/b] – [url="http://www.bimonkey.com/2009/05/the-audit-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Audit%20Transformation%20Basics%202005.dtsx"]2005[/url] – [url="http://www.bimonkey.com/uploads/componentreview/Audit%20Transformation%20Basics%202008.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Character Map[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Conditional Split[/b] – [url="http://www.bimonkey.com/2009/06/the-conditional-split-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Export%20Column%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Copy Column[/b] – [url="http://www.bimonkey.com/2009/06/the-copy-column-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Copy%20Column%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Data Conversion[/b] – [url="http://www.bimonkey.com/2009/06/the-data-conversion-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Data%20Conversion%20Transformation%20Basics%202005.zip"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b][url="http://www.bimonkey.com/support/ssis-component-samples-list/#"]Data Mining[/url] Query[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Derived Column[/b] – [url="http://www.bimonkey.com/2009/08/the-derived-column-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Derived%20Column%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Export Column[/b] – [url="http://www.bimonkey.com/2009/06/the-export-column-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Export%20Column%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Fuzzy Grouping [/b]- [url="http://www.bimonkey.com/2009/11/the-fuzzy-grouping-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Fuzzy%20Grouping%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Fuzzy Lookup[/b] – [url="http://www.bimonkey.com/2009/06/the-fuzzy-lookup-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Fuzzy%20Lookup%20Transformation%20Basics%202005.zip"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Import Column[/b] – [url="http://www.bimonkey.com/2009/09/the-import-column-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Import%20Column%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Lookup[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Merge[/b] – [url="http://www.bimonkey.com/2009/07/the-merge-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Merge%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Merge Join[/b] – [url="http://www.bimonkey.com/2010/10/the-merge-join-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Merge%20Join%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Multicast[/b] – [url="http://www.bimonkey.com/2009/07/the-multicast-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Multicast%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]OLE DB Command[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Percentage Sampling[/b] – [url="http://www.bimonkey.com/2009/06/the-percentage-sampling-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Aggregate%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Pivot[/b] – [url="http://www.bimonkey.com/2009/06/the-pivot-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Pivot%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Row Count[/b] – [url="http://www.bimonkey.com/2009/08/the-row-count-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Row%20Count%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Row Sampling[/b] – [url="http://www.bimonkey.com/2010/06/the-row-sampling-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Row%20Sampling%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Script Component[/b] – Article: [url="http://www.bimonkey.com/2009/09/the-script-transformation-part-2-as-a-source/"]Source[/url] / [url="http://www.bimonkey.com/2009/09/the-script-transformation-part-1-a-simple-transformation/"]Transformation[/url] / [url="http://www.bimonkey.com/2009/09/the-script-transformation-part-3-as-a-destination/"]Destination[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Script%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Slowly Changing Dimension[/b] – Article: [url="http://www.bimonkey.com/2009/07/the-slowly-changing-dimension-transformation-part-1/"]Type 1 (basics)[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Slowly%20Changing%20Dimension%20Transformation%20Basics%202005.zip"]2005[/url] – 2008 | [url="http://www.bimonkey.com/2009/08/the-slowly-changing-dimension-transformation-part-2-type-2-dimensions/"]Type 2[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Slowly%20Changing%20Transformation%20Type%202%202005.zip"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Sort[/b] – [url="http://www.bimonkey.com/2009/07/the-sort-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Sort%20Transformation%20Basics%202005.dtsx"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Term Extraction[/b] – [url="http://www.bimonkey.com/2009/07/the-term-extraction-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Term%20Extraction%20Transformation%20Basics%202005.zip"]2005[/url] – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Term Lookup[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Union All[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Unpivot[/b] – [url="http://www.bimonkey.com/2009/07/the-unpivot-transformation/"]Article[/url] – Samples: [url="http://www.bimonkey.com/uploads/componentreview/Unpivot%20Transformation%20Basics%202005.zip"]2005[/url] – 2008[/size][/font][/color]
[b] Data Flow Destinations[/b]
[color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Data Mining Model Training[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]DataReader Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Dimension Processing[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Excel Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Flat File Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]OLE DB Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Partition Processing[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Raw File Destination[/b] – [url="http://www.bimonkey.com/2009/04/the-raw-file-source-and-destination/"]Article[/url] – Samples: 2005 – [url="http://www.bimonkey.com/uploads/componentreview/Raw%20File%20Components%20Basics.dtsx"]2008[/url][/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]Recordset Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]SQL Server Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color][color=#333333][font=Arial, Tahoma, Verdana][size=3]
[b]SQL Server Mobile Destination[/b] – Article – Samples: 2005 – 2008[/size][/font][/color]

[erragulabi]

Does any one working on AWS cloud? and migration from SQL server 2008 to AWS?
If yes, so can you share your experiences

[9Pardhu]

Does any one know how shrinking works?

Shrinking of log files or data files?

how the data will be fragmented.... evaarinikina indetailed ga telisthe chepandi..i have few common questions