Ms Sql Server Technology Discussions

[deals2buy]

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]

Interview Question

How many 8-bit characters are there between '0' and 'Z' (inclusive) in the collation Latin1_General_CI_AS?

[ghazni]

[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]

[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]

[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]

[b] Parsing Parameters in a Stored Procedure[/b]



http://www.sqlservercentral.com/articles/Array/70702/

[deals2buy]

[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]

[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]

[b] Using SQL Server Concatenation Efficiently[/b]


http://www.mssqltips.com/sqlservertip/2777/using-sql-server-concatenation-efficiently/

[deals2buy]

[b] Tracking Database File AutoGrowth with Event Notifications[/b]


http://www.sqlservercentral.com/articles/autogrowth/93229/

[deals2buy]

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]

[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]

[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]

[b] SQL Server 2012: Installing Data Quality Services[/b]


http://www.databasejournal.com/features/mssql/sql-server-2012-installing-data-quality-services.html

[Desamudhuru]

[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