deals2buy Posted November 1, 2012 Report Posted November 1, 2012 Manipulating XML Data in SQL Server http://www.simple-talk.com/sql/database-administration/manipulating-xml-data-in-sql-server/ nenu eppudu XML data tho work cheyyaledu...so naaku deeni gurinchi asalu no idea..evarikaina use aithademo dekho
deals2buy Posted November 1, 2012 Report Posted November 1, 2012 Interview Question How many 8-bit characters are there between '0' and 'Z' (inclusive) in the collation Latin1_General_CI_AS?
ghazni Posted November 1, 2012 Report Posted November 1, 2012 [size=4][b][font=Arial, sans-serif]Design, development & testing work in Transact SQL, SSIS and SSRS [/font][/b][/size] [size=4][font=Arial, sans-serif][b]deeni mida skype interview undi em questions expect cheyochu...........[/b][/font][/size]
deals2buy Posted November 1, 2012 Report Posted November 1, 2012 [quote name='ghazni' timestamp='1351778475' post='1302722523'] [size=4][b][font=Arial, sans-serif]Design, development & testing work in Transact SQL, SSIS and SSRS [/font][/b][/size] [size=4][font=Arial, sans-serif][b]deeni mida skype interview undi em questions expect cheyochu...........[/b][/font][/size] [/quote] Design ante u may expect questions regarding data modelling...tools like ERWIN vaati gurinchi questions adagochu Development antava..idi mahaa samudram...company vaadi req ni batti aa questions adugutaadu..general ga desi gaallaithe functionality gurinchi adgutaaru... Testing ante again same as Dev but u try multiple scenarios here...
deals2buy Posted November 2, 2012 Report Posted November 2, 2012 [b] Function to Round Up Time to Nearest Minutes Interval[/b] [color=blue]CREATE FUNCTION [/color][color=black][dbo].[RoundTime] [/color][color=gray]([/color][color=#434343]@Time [/color][color=blue]DATETIME[/color][color=gray], [/color][color=#434343]@RoundToMin [/color][color=blue]INT[/color][color=gray])[/color] [color=blue]RETURNS DATETIME AS BEGIN RETURN [/color][color=magenta]ROUND[/color][color=gray]([/color][color=magenta]CAST[/color][color=gray]([/color][color=magenta]CAST[/color][color=gray]([/color][color=magenta]CONVERT[/color][color=gray]([/color][color=blue]VARCHAR[/color][color=gray],[/color][color=#434343]@Time[/color][color=gray],[/color][color=black]121[/color][color=gray]) [/color][color=blue]AS DATETIME[/color][color=gray]) [/color][color=blue]AS FLOAT[/color][color=gray]) * ([/color][color=black]1440[/color][color=gray]/[/color][color=#434343]@RoundToMin[/color][color=gray]),[/color][color=black]0[/color][color=gray])/([/color][color=black]1440[/color][color=gray]/[/color][color=#434343]@RoundToMin[/color][color=gray])[/color] [color=blue]END[/color] [color=black]GO[/color]
deals2buy Posted November 2, 2012 Report Posted November 2, 2012 [b] Parsing Parameters in a Stored Procedure[/b] http://www.sqlservercentral.com/articles/Array/70702/
deals2buy Posted November 2, 2012 Report Posted November 2, 2012 [b] SQL Server Function to return a range of dates[/b] http://www.mssqltips.com/sqlservertip/2800/sql-server-function-to-return-a-range-of-dates/
deals2buy Posted November 2, 2012 Report Posted November 2, 2012 [b] [url="http://www.sqlservercentral.com/blogs/ctrl-alt-geek/2012/10/31/dont-believe-everything-you-read-truncate-table-is-not-logged/"]Don’t believe everything you read: Truncate table is not logged[/url][/b]
deals2buy Posted November 6, 2012 Report Posted November 6, 2012 [b] Using SQL Server Concatenation Efficiently[/b] http://www.mssqltips.com/sqlservertip/2777/using-sql-server-concatenation-efficiently/
deals2buy Posted November 6, 2012 Report Posted November 6, 2012 [b] Tracking Database File AutoGrowth with Event Notifications[/b] http://www.sqlservercentral.com/articles/autogrowth/93229/
deals2buy Posted November 6, 2012 Report Posted November 6, 2012 ee questions ki answers cheppandi vayyaa evaraina? [color=rgb(42,42,42)]In SQL Server 2008 R2 and earlier versions, t[/color][font=Arial,sans-serif][size=1]he auto updating of statistics rules are:[/size][/font][list] [*][color=rgb(42,42,42)]Minimum threshold of 500 rows in the table.[/color] [*][color=rgb(42,42,42)]Fixed rate of change with a 20 percent threshold.[/color] [*][color=rgb(42,42,42)]Uses a default dynamic sample rate based on the # of rows. [/color] [/list] [color=rgb(42,42,42)]With the above rules a table containing 1,000,000 rows requires 200,000 changes before the auto updating of statistics is invoked. [/color][font=Arial,sans-serif][size=1]As a DBA you have determined that this is unacceptable in your situation. Thus you created and schedued a job to determine the number of changes in a table and if they exceeded your defined[/size][/font][font=Arial,sans-serif][size=1] limit you could/would invoke an update of the pertinent statistics. Due to changes in business conditions, data entry staff attendance, etc., etc, you find yourself continually having to alter the schedule of when your job runs. [/size][/font] [color=rgb(42,42,42)]I[/color][font=Arial,sans-serif][size=1]n SQL Server 2008 R2 SP1, which one of these is true:[/size][/font][list=1] [*][color=rgb(42,42,42)]Microsoft has altered the 20% threshold for auto updating of statistics.[/color][color=rgb(42,42,42)] [/color] [*][color=rgb(42,42,42)][size="2"]Microsoft has NOT altered the 20% threshold for auto [/size][/color][color=rgb(42,42,42)][size="2"]updating of statistics[/size][/color] [*][color=rgb(42,42,42)][size="2"]Microsoft released a trace flag which will change the fixed rate of the 20% threshold for update statistics into a dynamic percentage rate.[/size][/color] [/list]
deals2buy Posted November 7, 2012 Report Posted November 7, 2012 [b] Stairway to Transaction Log Management in SQL Server, Level 6: Managing the Log in BULK_LOGGED Recovery Model[/b] http://www.sqlservercentral.com/articles/Stairway+Series/94552/
deals2buy Posted November 7, 2012 Report Posted November 7, 2012 [quote name='deals2buy' timestamp='1352212637' post='1302751539'] ee questions ki answers cheppandi vayyaa evaraina? [color=rgb(42,42,42)]In SQL Server 2008 R2 and earlier versions, t[/color][font=Arial,sans-serif][size=1]he auto updating of statistics rules are:[/size][/font][list] [*][color=rgb(42,42,42)]Minimum threshold of 500 rows in the table.[/color] [*][color=rgb(42,42,42)]Fixed rate of change with a 20 percent threshold.[/color] [*][color=rgb(42,42,42)]Uses a default dynamic sample rate based on the # of rows. [/color] [/list] [color=rgb(42,42,42)]With the above rules a table containing 1,000,000 rows requires 200,000 changes before the auto updating of statistics is invoked. [/color][font=Arial,sans-serif][size=1]As a DBA you have determined that this is unacceptable in your situation. Thus you created and schedued a job to determine the number of changes in a table and if they exceeded your defined[/size][/font][font=Arial,sans-serif][size=1] limit you could/would invoke an update of the pertinent statistics. Due to changes in business conditions, data entry staff attendance, etc., etc, you find yourself continually having to alter the schedule of when your job runs. [/size][/font] [color=rgb(42,42,42)]I[/color][font=Arial,sans-serif][size=1]n SQL Server 2008 R2 SP1, which one of these is true:[/size][/font][list=1] [*][color=rgb(42,42,42)]Microsoft has altered the 20% threshold for auto updating of statistics.[/color][color=rgb(42,42,42)] [/color] [*][color=rgb(42,42,42)][size=2]Microsoft has NOT altered the 20% threshold for auto [/size][/color][color=rgb(42,42,42)][size=2]updating of statistics[/size][/color] [*][color=rgb(42,42,42)][size=2]Microsoft released a trace flag which will change the fixed rate of the 20% threshold for update statistics into a dynamic percentage rate.[/size][/color] [/list] [/quote] [b]Answer: [/b]Micrisoft released a trace flag which will change the fixed rate of the 20% threshold for update statistics into a dynamic percentage rate [b]Explanation: [/b]In order to activate this new logic, you need to enable traceflag 2371. As a result the threshold to trigger update statistics will be calculated based on the number of rows in the table. However, the table still needs to have a minimum of 500 rows as the minimum row threshold did not change. As before the update of the statistics will apply the default sample rate which is dynamic and based on the # of rows. nee yavvva okkadu kuda ee thread chudatam leda?
deals2buy Posted November 7, 2012 Report Posted November 7, 2012 [b] SQL Server 2012: Installing Data Quality Services[/b] http://www.databasejournal.com/features/mssql/sql-server-2012-installing-data-quality-services.html
Desamudhuru Posted November 7, 2012 Report Posted November 7, 2012 [quote name='deals2buy' timestamp='1352300019' post='1302757419'] [b]Answer: [/b]Micrisoft released a trace flag which will change the fixed rate of the 20% threshold for update statistics into a dynamic percentage rate [b]Explanation: [/b]In order to activate this new logic, you need to enable traceflag 2371. As a result the threshold to trigger update statistics will be calculated based on the number of rows in the table. However, the table still needs to have a minimum of 500 rows as the minimum row threshold did not change. As before the update of the statistics will apply the default sample rate which is dynamic and based on the # of rows. nee yavvva okkadu kuda ee thread chudatam leda? [/quote] chusa bhayya kani answer teliyaka musukuna
Recommended Posts