metafor

date range with recursive cte

2012-01-03T11:08:00.001+02:00

WITH

DATE_RANGE as (

SELECT

[date]=GETDATE()

UNION ALL

SELECT DATEADD(day,1,[date])

FROM DATE_RANGE

WHERE DATEADD(day,1,[date])<=DATEADD(day,10,GETDATE())

)

SELECT * FROM DATE_RANGE

the Size Of All Tables

2011-12-26T14:30:00.001+02:00

SET NOCOUNT ON

DBCC UPDATEUSAGE(0)

-- DB size.

EXEC sp_spaceused

-- Table row counts and sizes.

CREATE TABLE #t
(
    [name] NVARCHAR(128),
    [rows] CHAR(11),
    reserved VARCHAR(18),
    data VARCHAR(18),
    index_size VARCHAR(18),
    unused VARCHAR(18)
)

INSERT #t EXEC sp_msForEachTable 'EXEC sp_spaceused ''?'''

SELECT *
FROM   #t

-- # of rows.

SELECT SUM(CAST([rows] AS int)) AS [rows]
FROM #t

DROP TABLE #t

compare identitcal files of folder

2011-12-02T17:20:00.001+02:00

:bof

@echo off
setlocal

:init

    set dirDEST=d:\TEST\NEW\
    set dirSOURCE=d:\TEST\OLD\

if not exist "%dirDEST%" echo dirDEST not found & goto :EOF
if not exist "%dirSOURCE%" echo dirSOURCE not found & goto :EOF

for /f "delims=" %%a in ('dir /b /a-d "%dirDEST%" 2^>NUL') do if not exist "%dirSOURCE%%%a" echo %%a does not exist in "dirSOURCE"
for /f "delims=" %%a in ('dir /b /a-d "%dirSOURCE%" 2^>NUL') do if not exist "%dirDEST%%%a" echo %%a does not exist in "dirDEST"

:eof

Ad hoc update to system catalogs is not supported

2011-11-30T16:35:00.001+02:00

EXEC sp_configure 'show advanced options', 1;

RECONFIGURE WITH OVERRIDE

EXEC sp_configure 'xp_cmdshell', 1

RECONFIGURE WITH OVERRIDE

sp_configure 'Ole Automation Procedures', 1;

RECONFIGURE WITH OVERRIDE

Windows Mobile Compact Framework- Executing Path/Directory

2011-07-19T09:38:00.001+03:00

System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().FullName.CodeBase)

compact framework does not support

AppDomain.CurrentDomain.BaseDirectory

System.Environment.CurrentDirectory

Application.StartupPath

EXECUTE permission was denied on the object

2011-07-12T14:56:00.001+03:00

exec sp_grantdbaccess N'www1-w(username)', 'DBNAME'

GRANT EXECUTE ON objectname TO public

SELECT * FROM master.sys.database_permissions AS dp

JOIN sys.system_objects AS so

ON dp.major_id = so.object_id

WHERE dp.class = 1 AND so.parent_object_id = 0 ;

Find Running Queries

2011-07-06T14:23:00.001+03:00

SELECT sqltext.TEXT,

req.session_id,

req.status,

req.command,

req.cpu_time,

req.total_elapsed_time

FROM sys.dm_exec_requests req

CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS sqltext

KILL [session_id]

SQL SERVER NAME

2011-07-04T16:11:00.001+03:00

SELECT @@SERVERNAME

Select * from sysservers where srvid = 0

Select Host_Name() as Computer_Name

EXEC xp_getNetName

SELECT CONVERT(sysname, SERVERPROPERTY(N'servername'))

ALL TABLES Row size and count

2011-07-04T09:36:00.001+03:00

DECLARE @temp as TABLE (

NAME VARCHAR(100) ,

ROWS INT,

RESERVED VARCHAR(100),

DATA VARCHAR(100),

INDEX_SIZE VARCHAR(100),

UNUSED VARCHAR(100))

INSERT INTO @temp EXEC sp_msforEachTable " exec sp_spaceused '?' "

SELECT * FROM @temp

javascript ajax long polling- with jQuery

2011-05-31T09:15:00.001+03:00

Specific methods of implementing Comet fall into two major categories: streaming and long polling.

Streaming

An application using streaming Comet opens a single persistent connection from the client browser to the server for all Comet events. These events are incrementally handled and interpreted on the client side every time the server sends a new event, with neither side closing the connection.^[3]

Specific techniques for accomplishing streaming Comet include the following:

Hidden iframe

A basic technique for dynamic web application is to use a hidden iframe HTML element (an <I>inline frame</I>, which allows a website to embed one HTML document inside another). This invisible iframe is sent as a chunked block, which implicitly declares it as infinitely long (sometimes called “forever frame”). As events occur, the iframe is gradually filled with script tags, containing JavaScript to be executed in the browser. Because browsers render HTML pages incrementally, each script tag is executed as it is received.^[11]

One benefit of the iframe method is that it works in every common browser. Two downsides of this technique are the lack of a reliable error handling method, and the impossibility of tracking the state of the request calling process.^[11]

XMLHttpRequest

The XMLHttpRequest (XHR) object, the main tool used by Ajax applications for browser–server communication, can also be pressed into service for server–browser Comet messaging, in a few different ways.

In 1995, Netscape Navigator added a feature called “server push”, which allowed servers to send new versions of an image or HTML page to that browser, as part of a multipart HTTP response (see History section, below), using the content type multipart/x-mixed-replace. Since 2004, Gecko-based browsers such as Firefox accept multipart responses to XHR, which can therefore be used as a streaming Comet transport.^[12] On the server side, each message is encoded as a separate portion of the multipart response, and on the client, the callback function provided to the XHR onreadystatechange function will be called as each message arrives. This functionality is only included in Gecko-based browsers, though there is discussion of adding it to WebKit.^[13]

Instead of creating a multipart response, and depending on the browser to transparently parse each event, it is also possible to generate a custom data format for an XHR response, and parse out each event using browser-side JavaScript, relying only on the browser firing the onreadystatechange callback each time it receives new data.

Ajax with long polling

None of the above streaming transports works across all modern browsers without negative side-effects. This forces Comet developers to implement several complex streaming transports, switching between them depending on the browser. Consequently many Comet applications use long polling, which is easier to implement on the browser side, and works, at minimum, in every browser that supports XHR. As the name suggests, long polling requires the client to poll the server for an event (or set of events). The browser makes an Ajax-style request to the server, which is kept open until the server has new data to send to the browser, which is sent to the browser in a complete response. The browser initiates a new long polling request in order to obtain subsequent events.

Specific technologies for accomplishing long-polling include the following:

XMLHttpRequest long polling

For the most part, XMLHttpRequest long polling works like any standard use of XHR. The browser makes an asynchronous request of the server, which may wait for data to be available before responding. The response can contain encoded data (typically XML or JSON) or Javascript to be executed by the client. At the end of the processing of the response, the browser creates and sends another XHR, to await the next event. Thus the browser always keeps a request outstanding with the server, to be answered as each event occurs.

Script tag long polling

While any Comet transport can be made to work across subdomains, none of the above transports can be used across different second-level domains (SLDs), due to browser security policies designed to prevent cross-site scripting attacks.^[14] That is, if the main web page is served from one SLD, and the Comet server is located at another SLD, Comet events cannot be used to modify the HTML and DOM of the main page, using those transports. This problem can be side-stepped by creating a proxy server in front of one or both sources, making them appear to originate from the same domain. However, this is often undesirable for complexity or performance reasons.

Unlike iframes or XMLHttpRequest objects, script tags can be pointed at any URI, and JavaScript code in the response will be executed in the current HTML document. This creates a potential security risk for both servers involved, though the risk to the data provider (in our case, the Comet server) can be avoided using JSONP.

A long-polling Comet transport can be created by dynamically creating script elements, and setting their source to the location of the Comet server, which then sends back JavaScript (or JSONP) with some event as its payload. Each time the script request is completed, the browser opens a new one, just as in the XHR long polling case. This method has the advantage of being cross-browser while still allowing cross-domain implementations.^[14]

^{referrer : http://en.wikipedia.org/wiki/Comet_%28programming%29}

$(document).ready(function () {

var ctr = 1;

$.PeriodicalUpdater('@Url.Content("~/SupportService/MessageQueue")', {

minTimeout: 10 * 1000,

maxTimeout: 10 * 60 * 1000,

multiplier: 2.3,

type: 'json',

data: function () { return ctr++; },

cache: true

}, function (data) {

$('#curtime').html(data.curtime);

});

</script>

jsfile : https://github.com/RobertFischer/JQuery-PeriodicalUpdater/

demo : http://demo.smokejumperit.com/demo.html

RobertFischer / JQuery-PeriodicalUpdater

A port of Prototype's Ajax.PeriodicalUpdater function to jQuery.

Basically, this function polls some remote service at fairly regular internvals, and (optionally) processes the result via a callback. The period of calls will decay as long as the same response keeps coming back from the server (either in the form of repeated data or in the form of a 304 Not Modified status), which reduces the load on the server naturally. The first Ajax call happens as a page 'onReady' handler (ie: the jQuery(function) call), so it is safe to put the PeriodicalUpdater call anywhere on the page.

Usage: $.PeriodicalUpdater('/path/to/service', { method: 'get', // method; get or post data: '', // array of values to be passed to the page - e.g. {name: "John", greeting: "hello"} minTimeout: 1000, // starting value for the timeout in milliseconds maxTimeout: 8000, // maximum length of time between requests multiplier: 2, // the amount to expand the timeout by if the response hasn't changed (up to maxTimeout) type: 'text', // response type - text, xml, json, etc. See $.ajax config options maxCalls: 0, // maximum number of calls. 0 = no limit. autoStop: 0 // automatically stop requests after this many returns of the same data. 0 = disabled. }, function(remoteData, success, xhr, handle) { // Process the new data (only called when there was a change) });

The "data" value can be one of three things:

A scalar, in which case it will be used constantly.
A JSON map/object, in which case it will be turned into key/value pairs by jQuery
An anonymous function, in which case it will be executed before each AJAX call. See jQuery.ajax for more information.

Any of the other standard $.ajax configuration options can be passed to the setting map.
The only exception is the flag that treats modifications as errors. That’s always going to be 'true'.

The function call returns a handle. You can call .stop() on this handle in order to stop the updating and ignore any subsequent responses. If the maximum number of calls, .stop(), or the autoStop has been triggered, you can restart the updater using .restart() on the handle. This handle is also passed into the callback function as the fourth argument.

More info, including advantages over 360innovate version, see the blog post on EnfranchisedMind.

referrer: https://github.com/RobertFischer/JQuery-PeriodicalUpdater/blob/master/README.md

Razor render- MVC3 View Render to String

2011-05-26T09:51:00.001+03:00

public static string RazorRender(Controller context, string DefaultAction)

{

string Cache = string.Empty;

System.Text.StringBuilder sb = new System.Text.StringBuilder();

System.IO.TextWriter tw = new System.IO.StringWriter(sb);

RazorView view_ = new RazorView(context.ControllerContext, DefaultAction, null, false, null);

view_.Render(new ViewContext(context.ControllerContext, view_, new ViewDataDictionary(), new TempDataDictionary(), tw), tw);

Cache = sb.ToString();

return Cache;

}

public static string RenderRazorViewToString(string viewName, object model)

{

ViewData.Model = model;

using (var sw = new StringWriter())

{

var viewResult = ViewEngines.Engines.FindPartialView(ControllerContext, viewName);

var viewContext = new ViewContext(ControllerContext, viewResult.View, ViewData, TempData, sw);

viewResult.View.Render(viewContext, sw);

return sw.GetStringBuilder().ToString();

}

public static class HtmlHelperExtensions

{

public static string RenderPartialToString(ControllerContext context, string partialViewName, ViewDataDictionary viewData, TempDataDictionary tempData)

{

ViewEngineResult result = ViewEngines.Engines.FindPartialView(context, partialViewName);

if (result.View != null)

{

StringBuilder sb = new StringBuilder();

using (StringWriter sw = new StringWriter(sb))

{

using (HtmlTextWriter output = new HtmlTextWriter(sw))

{

ViewContext viewContext = new ViewContext(context, result.View, viewData, tempData, output);

result.View.Render(viewContext, output);

}

return sb.ToString();

}

return String.Empty;

}

Performance counter registry hive consistency Problem

2011-05-11T10:23:00.001+03:00

string.Format("{0,3}", CultureInfo.InstalledUICulture.Parent.LCID.ToString("X")).Replace(" ", "0");

referer:

http://connect.microsoft.com/SQLServer/feedback/details/312847/performance-counter-registry-hive-consistency-check-failed-at-traditional-chinese-windows-server-2003

http://answers.microsoft.com/en-us/windows/forum/windows_7-windows_install/performance-counter-registry-hive-consistency/1b7be71f-7682-4204-8be0-80b2eaf0be67

http://blogs.msdn.com/b/joaol/archive/2008/12/18/sql-server-2008-performance-counters-registry-hive-consistency-fails-on-non-english-operating-systems.aspx

difference between two date–iki tarih arasındaki zaman farkı

2011-05-09T13:45:00.001+03:00

public string LoopAge(DateTime myDOB, DateTime FutureDate)

{

int years = 0;

int months = 0;

int days = 0;

DateTime tmpMyDOB = new DateTime(myDOB.Year, myDOB.Month, 1);

DateTime tmpFutureDate = new DateTime(FutureDate.Year, FutureDate.Month, 1);

while (tmpMyDOB.AddYears(years).AddMonths(months) < tmpFutureDate)

{

months++;

if (months > 12)

{

years++;

months = months - 12;

}

if (FutureDate.Day >= myDOB.Day)

{

days = days + FutureDate.Day - myDOB.Day;

}

else

{

months--;

if (months < 0)

{

years--;

months = months + 12;

}

days = days + (DateTime.DaysInMonth(FutureDate.AddMonths(-1).Year, FutureDate.AddMonths(-1).Month) + FutureDate.Day) - myDOB.Day;

}

//add an extra day if the dob is a leap day

if (DateTime.IsLeapYear(myDOB.Year) && myDOB.Month == 2 && myDOB.Day == 29)

{

//but only if the future date is less than 1st March

if(FutureDate >= new DateTime(FutureDate.Year, 3,1))

days++;

}

return "Years: " + years + " Months: " + months + " Days: " + days;

}

public void LoopAge(DateTime myDOB, DateTime FutureDate)

{

int years = 0;

int months = 0;

int days = 0;

DateTime tmpMyDOB = new DateTime(myDOB.Year, myDOB.Month, 1);

DateTime tmpFutureDate = new DateTime(FutureDate.Year, FutureDate.Month, 1);

while (tmpMyDOB.AddYears(years).AddMonths(months) < tmpFutureDate)

{

months++;

if (months > 12)

{

years++;

months = months - 12;

}

if (FutureDate.Day >= myDOB.Day)

{

days = days + FutureDate.Day - myDOB.Day;

}

else

{

months--;

if (months < 0)

{

years--;

months = months + 12;

}

days +=

DateTime.DaysInMonth(

FutureDate.AddMonths(-1).Year, FutureDate.AddMonths(-1).Month

) + FutureDate.Day - myDOB.Day;

}

//add an extra day if the dob is a leap day

if (DateTime.IsLeapYear(myDOB.Year) && myDOB.Month == 2 && myDOB.Day == 29)

{

//but only if the future date is less than 1st March

if (FutureDate >= new DateTime(FutureDate.Year, 3, 1))

days++;

}

C# TSQL Assembly Code

2011-05-09T10:27:00.001+03:00

using System;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

[Microsoft.SqlServer.Server.SqlFunction]

public static SqlString datediff2()

{

// Put your code here

return new SqlString("Hello");

}

};

sp_configure 'clr enabled', 1

RECONFIGURE

ALTER DATABASE [AngelAdmin] SET TRUSTWORTHY ON

CREATE Function datediff2() RETURNS NVARCHAR(1024)

EXTERNAL NAME TASQLHelper.UserDefinedFunctions.datediff2

SELECT dbo.datediff2()

SQL JOIN TABLE VALUE TO STRING

2011-04-20T16:55:00.001+03:00

SELECT STUFF((SELECT ',' + ISMI FROM MAGAZA_TANIM FOR XML PATH('')),1, 1, '')

ANKARA,ISTANBUL,IZMIR....

Split string with parsename- sql virtual array

2011-04-16T13:21:00.001+03:00

DECLARE @test nvarchar(256)= 'lorem.er.deneme.test'

SELECT PARSENAME(@test,1),PARSENAME(@test,3),PARSENAME(@test,2),PARSENAME(@test,4)

DECLARE @FullName NVARCHAR(500)

SET @FullName = N'Flintstone, Mr.Fred, Jr'

SELECT PARSENAME(FName, 3) AS "Title",

PARSENAME(FName, 2) AS "FirstName",

PARSENAME(FName, 4) AS "LastName",

PARSENAME(FName, 1) AS "Prefix"

FROM ( SELECT REPLACE(@FullName, ', ', '.')) D(FName)

T-SQL DATENAME Turkish–Türkçe gün isimleri

2011-04-15T13:54:00.001+03:00

SELECT

DATENAME(dw, TimeStart) AS DayOfWeek,

DATEPART(dw, TimeStart) AS DayNum

FROM ExecutionLogs

GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

DayOfWeek DayNum

------------------------------ -----------

Wednesday 4

Tuesday 3

Sunday 1

Friday 6

Thursday 5

Saturday 7

Monday 2

(7 row(s) affected)

SET LANGUAGE Turkish;

SELECT

DATENAME(dw, TimeStart) AS DayOfWeek,

DATEPART(dw, TimeStart) AS DayNum

FROM ExecutionLogs

GROUP BY DATENAME(dw, TimeStart), DATEPART(dw, TimeStart)

Changed language setting to Türkçe.

DayOfWeek DayNum

------------------------------ -----------

Perşembe 4

Pazartesi 1

Pazar 7

Salı 2

Cumartesi 6

Cuma 5

Çarşamba 3

(7 row(s) affected)

T-SQL system stored procedures 1

2011-04-15T10:54:00.001+03:00

EXEC sp_spaceused

EXEC sp_spaceused dbo.table_name

database_name database_size unallocated space

-------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------

master 5.25 MB 1.52 MB

reserved data index_size unused

------------------ ------------------ ------------------ ------------------

2536 KB 1160 KB 1040 KB 336 KB

Shrink log file

USE [master]

ALTER DATABASE [REPORT] SET RECOVERY SIMPLE WITH NO_WAIT

DBCC SHRINKFILE(ANGEL_log, 1)

ALTER DATABASE [REPORT] SET RECOVERY FULL WITH NO_WAIT

Change Server Name –SQL Server Instance adını değiştirme

SELECT @@SERVERNAME AS 'Server Name'

sp_dropserver 'OLD_NAME'

sp_addserver 'NEW_NAME', local

Restart sql server instance

Adding Custom error message

Exec sp_addmessage

@msgnum=50002,

@severity=12,

@msgtext='error while %s description ;',

@with_log='False',

@replace='replace'

select * from sys.messages

send mail to operator

EXECUTE

msdb.dbo.sp_notify_operator

@name=N'operator name',@subject=N'subject of mail',

@body=N'content of mail message'

Requests of sql server **

SELECT

r.session_id,

r.blocking_session_id,

s.program_name,

s.host_name,

t.text

FROM

sys.dm_exec_requests r

INNER JOIN sys.dm_exec_sessions s ON r.session_id = s.session_id

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) t

WHERE

s.is_user_process = 1

report server subscription- agent list

SELECT

Schedule.ScheduleID as SubscriptionID,

Subscriptions.*,

Schedule.ScheduleID AS SQLAgent_Job_Name,

Subscriptions.Description AS sub_desc, Subscriptions.DeliveryExtension AS sub_delExt,

[Catalog].Name AS ReportName, [Catalog].Path AS ReportPath

FROM ReportServer.dbo.ReportSchedule

INNER JOIN ReportServer.dbo.Schedule ON ReportServer.dbo.ReportSchedule.ScheduleID = Schedule.ScheduleID

INNER JOIN ReportServer.dbo.Subscriptions ON ReportServer.dbo.ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID

INNER JOIN ReportServer.dbo.[Catalog] ON ReportServer.dbo.ReportSchedule.ReportID = [Catalog].ItemID AND Subscriptions.Report_OID = [Catalog].ItemID

WHERE

Subscriptions.DeliveryExtension = 'Report Server Email'

compare two tables dynamic- tablo sütunları karşılaştırma

2011-04-15T10:28:00.001+03:00

DECLARE @dbname1 nvarchar(48) =N'ERP'

DECLARE @dbname2 nvarchar(48) =N'AERP'

DECLARE @TableName nvarchar(48) =N'FATURA'

SELECT * FROM (

SELECT

@dbname1 as DBNAME,

clmns.name AS [Name],

usrt.name AS [DataType],

ISNULL(baset.name, N'') AS [SystemType],

CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND clmns.max_length <> -1 THEN

clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length],

CAST(clmns.precision AS int) AS [NumericPrecision]

FROM

ERP.sys.tables AS tbl

INNER JOIN ERP.sys.all_columns AS clmns ON clmns.object_id=tbl.object_id

LEFT OUTER JOIN ERP.sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id

LEFT OUTER JOIN ERP.sys.types AS baset ON baset.user_type_id = clmns.system_type_id and

baset.user_type_id = baset.system_type_id

WHERE

(tbl.name=@TableName and SCHEMA_NAME(tbl.schema_id)=N'dbo') )as ERP

LEFT JOIN (

SELECT

@dbname2 as DBNAME,

clmns.name AS [Name],

usrt.name AS [DataType],

ISNULL(baset.name, N'') AS [SystemType],

CAST(CASE WHEN baset.name IN (N'nchar', N'nvarchar') AND clmns.max_length <> -1 THEN

clmns.max_length/2 ELSE clmns.max_length END AS int) AS [Length],

CAST(clmns.precision AS int) AS [NumericPrecision]

FROM

AERP.sys.tables AS tbl

INNER JOIN AERP.sys.all_columns AS clmns ON clmns.object_id=tbl.object_id

LEFT OUTER JOIN AERP.sys.types AS usrt ON usrt.user_type_id = clmns.user_type_id

LEFT OUTER JOIN AERP.sys.types AS baset ON baset.user_type_id = clmns.system_type_id and

baset.user_type_id = baset.system_type_id

WHERE

(tbl.name=@TableName and SCHEMA_NAME(tbl.schema_id)=N'dbo') ) AERP

ON ERP.Name = AERP.Name

WHERE

ERP.[Length] <> AERP.[Length]

SQL SERVER DBCC

2011-03-11T23:19:00.001+02:00

exec sp_who2
kill 54

DBCC PAGE (db, 1, 26839, 1)
DBCC CHECKDB(db, REPAIR_ALLOW_DATA_LOSS)
alter database db set MULTI_USER

;--------------

The error is pretty benign - it's not an actual corruption. It's saying that the PFS (Page Free Space) entry for that page has the wrong amount of free space noted - 100% instead of 0%. All this means is that the page may be picked up be a free-space scanner looking to insert data into a text page and it will find the page is actually full and move on to the next page.

All repair will do is set the correct free space setting, but you'll need to take the database into single-user mode (essentially offline) to do it.

These errors occured reasonably frequently on SQL 2000 as the algorithm to keep track of free space (only tracked for heap and text pages) had some holes in it. They should be fixed in 2005. Is this database recently upgraded from 2000, or is this the first time CHECKDB has been run since it was upgraded?

To use DBCC PAGE, you need to specify the database name too:

DBCC PAGE ('DATABASENAME', 1, 26839, 1)

should do it for you.

Thanks

-------------------------------------------------------

alter database db set SINGLE_USER;

DBCC CHECKDB('db', REPAIR_REBUILD);

alter database db set MULTI_USER;

http://msdn.microsoft.com/en-us/library/aa226363%28v=sql.80%29.aspx

http://msdn.microsoft.com/en-us/library/ms188236.aspx

http://msdn.microsoft.com/en-us/library/ms345598.aspx

http://www.cryer.co.uk/brian/sqlserver/howto_start_single_user_mode.htm

http://publib.boulder.ibm.com/tividd/td/BSM/SC32-9084-00/en_US/HTML/bsmd242.htm

http://www.sql-server-pro.com/dbcc-checkdb.html

http://msdn.microsoft.com/en-us/library/ms176064.aspx

http://msdn.microsoft.com/en-us/library/aa258278%28v=sql.80%29.aspx

Aero Style Forms

2011-01-15T19:33:00.001+02:00

#region ----- Aero Form

[System.Runtime.InteropServices.StructLayout(System.Runtime.InteropServices.LayoutKind.Sequential)]

public struct MARGINS

{

public int Left;

public int Right;

public int Top;

public int Bottom;

}

private MARGINS margins;

[System.Runtime.InteropServices.DllImport("dwmapi.dll", PreserveSig = false)]

public static extern void DwmExtendFrameIntoClientArea

(IntPtr hwnd, ref MARGINS margins);

[System.Runtime.InteropServices.DllImport("dwmapi.dll", PreserveSig = false)]

public static extern bool DwmIsCompositionEnabled();

protected override void OnLoad(EventArgs e)

{

base.OnLoad(e);

if (DwmIsCompositionEnabled())

{

// Paint the glass effect.

margins = new MARGINS();

margins.Top = 50;

DwmExtendFrameIntoClientArea(this.Handle, ref margins);

}

protected override void OnPaintBackground(PaintEventArgs e)

{

base.OnPaint(e);

if (DwmIsCompositionEnabled())

{

// paint background black to enable include glass regions

e.Graphics.Clear(Color.Black);

// revert the non-glass rectangle back to it's original colour

Rectangle clientArea = new Rectangle(

margins.Left,

margins.Top,

this.ClientRectangle.Width - margins.Left - margins.Right,

this.ClientRectangle.Height - margins.Top - margins.Bottom

);

Brush b = new SolidBrush(this.BackColor);

e.Graphics.FillRectangle(b, clientArea);

}

#endregion

Service Broker kullanımı

2010-10-09T20:10:00.001+03:00

SQL Server 2005 veya 2008 üzerinde service broker nesnesinin kullanımı.

ornekdb isimli bir database oluşturulması

ornekdb service broker erişimi ve service broker’ın aktifleştirilmesi

Select is_broker_enabled From sys.databases Where database_id=db_id()

ALTER DATABASE ornekdb SET ENABLE_BROKER

tanımların yapılması



CREATE MESSAGE TYPE mesaj VALIDATION = WELL_FORMED_XML ;

CREATE CONTRACT kontrat ( mesaj SENT BY INITIATOR);

CREATE QUEUE [dbo].[gondermeKuyrugu];
CREATE QUEUE [dbo].[almaKuyrugu];

CREATE SERVICE gondermeServisi ON QUEUE [dbo].[gondermeKuyrugu];
CREATE SERVICE almaServisi ON QUEUE [dbo].[almaKuyrugu] (kontrat);

mesaj gönderme


BEGIN TRANSACTION ; 

    -- mesaj oluşturulması

    DECLARE @mesaj XML ;
    SET @mesaj = N'<mesaj>Merhaba, Dünya!</mesaj>' ;

    -- baslatılan karsilasmanın referansının
    -- tutulması

    DECLARE @karsilasmaReferansi UNIQUEIDENTIFIER ;

    -- Karşılaşma.

    BEGIN DIALOG CONVERSATION @karsilasmaReferansi
        FROM SERVICE gondermeServisi
        TO SERVICE 'almaServisi'
        ON CONTRACT kontrat 
        WITH ENCRYPTION = OFF;

    -- Send the message on the dialog.

    SEND ON CONVERSATION @karsilasmaReferansi
      MESSAGE TYPE mesaj
      (@mesaj) ;

-- işlem tamalanıyor. Service Broker
-- mesaj hedefe ulaştırılır

COMMIT TRANSACTION ;
GO

mesaj alma


-- Grup bazında işlem
WHILE (1 = 1)
BEGIN

DECLARE @karsilasmaReferansi UNIQUEIDENTIFIER,
        @karsilasmaGrup  UNIQUEIDENTIFIER,
        @mesajIcerigi XML,
        @mesajTipAdi NVARCHAR(128);

BEGIN TRANSACTION ;

-- grubun tutulması

WAITFOR(
   GET CONVERSATION GROUP @karsilasmaGrup FROM [dbo].[almaKuyrugu]),
   TIMEOUT 500 ;

-- eger karşılaşma grubu kalmadıysa işlemin
-- dış döngünün dışına çıkarılması

IF @karsilasmaGrup IS NULL
BEGIN
    ROLLBACK TRANSACTION ;
    BREAK ;
END ;

    -- grup içerisindeki mesajların işleme alınması. 

    WHILE 1 = 1
    BEGIN

        -- grup için mesajın alınması 'where' yazımı ile
        -- aynı gruba ait mesajın işleme alınması

        RECEIVE
           TOP(1)
           @karsilasmaReferansi = conversation_handle,
           @mesajTipAdi = message_type_name,
           @mesajIcerigi =
           CASE
              WHEN validation = 'X' THEN CAST(message_body AS XML)
              ELSE CAST(N'<none/>' AS XML)
          END
        FROM [dbo].[almaKuyrugu]
        WHERE conversation_group_id = @karsilasmaGrup ;

        -- eger mesaj yoksa veya hata olustuysa işlemi durdur,

        IF @@ROWCOUNT = 0 OR @@ERROR <> 0 BREAK;

        -- gelen mesajın gösterilmesi / seçilmesi

        SELECT 'Conversation Group Id' = @karsilasmaGrup,
               'Conversation Handle' = @karsilasmaReferansi,
               'Message Type Name' = @mesajTipAdi,
               'Message Body' = @mesajIcerigi ;

        -- karşılaşmanın sonlandırılması

        END CONVERSATION @karsilasmaReferansi ;

    END;

   -- işlemlerin onaylanması

   COMMIT TRANSACTION ;

END ; -- bütün gruplar
GO

MVC Page URL Relative

2010-10-09T16:23:00.001+03:00

<link href="<%= 
        Page.ResolveUrl("~/Content/core/css/smoothness/jquery-ui-1.8.1.custom.css") %>" 
            rel="stylesheet" 
            type="text/css" />  
<link href='<%= 
        Url.Content("~/Plugins/Views/Webilan/Content/Main.css") %>' 
            rel="stylesheet" 
            type="text/css">
<link rel="stylesheet" type="text/css" media="screen" 
        href='<%= VirtualPathUtility.ToAbsolute(
                    string.Format("~/Content/{0}/css/Site.css", 
                    PostSystem.ThemeName )) %>' />

LINQ to SQL query with dynamic OrderBy

2010-09-19T21:12:00.001+03:00

public static class DynamicOrderBy
{

    public static IQueryable<TEntity> OrderBy<TEntity>(this IQueryable<TEntity> source, string orderByProperty,
                  bool desc) where TEntity : class
    {

        string command = desc ? "OrderByDescending" : "OrderBy";

        var type = typeof(TEntity);
        var property = type.GetProperty(orderByProperty);
        var parameter = System.Linq.Expressions.Expression.Parameter(type, "p");
        var propertyAccess = System.Linq.Expressions.Expression.MakeMemberAccess(parameter, property);
        var orderByExpression = System.Linq.Expressions.Expression.Lambda(propertyAccess, parameter);

        var resultExpression = 
            System.Linq.Expressions.Expression.Call(typeof(Queryable), command, new Type[] { type, property.PropertyType },
                               source.Expression, System.Linq.Expressions.Expression.Quote(orderByExpression));

        return source.Provider.CreateQuery<TEntity>(resultExpression);

    }

reference :

http://blogs.msdn.com/b/swiss_dpe_team/archive/2008/06/05/composable-linq-to-sql-query-with-dynamic-orderby.aspx

http://stackoverflow.com/questions/307512/how-do-i-apply-orderby-on-an-iqueryable-using-a-string-column-name-within-a-gener

C#: Equivalent of JavaScript escape function

2010-09-08T18:27:00.001+03:00

Uri.EscapeDataString("KC's trick /Hello") gives:
"KC's%20trick%20%2FHello"
Uri.EscapeUriString("KC's trick /Hello") gives:
"KC's%20trick%20/Hello"
System.Web.HttpUtility.UrlEncode("KC's trick /Hello") gives:
"KC's+trick+%2fHello"
System.Web.HttpUtility.UrlPathEncode("KC's trick /Hello") gives:
"KC's%20trick%20/Hello"

reference :http://kseesharp.blogspot.com/2008/01/c-equivalent-of-javascript-escape.html

XML node

2010-07-07T00:51:00.001+03:00

            XmlNamespaceManager nsmgr = new XmlNamespaceManager(xmlFile.NameTable);
            nsmgr.AddNamespace("smap", "http://schemas.microsoft.com/AspNet/SiteMap-File-1.0");
            string xpath = "//smap:siteMapNode[@url=\"{0}\"]";
            string url = "~/Index";

            return GetSiteMapNodeFromElement((XmlElement)xmlFile.SelectSingleNode(String.Format(xpath, url), nsmgr));

Google Font api

2010-06-13T20:47:00.001+03:00

The Google Font API helps you add web fonts to any web page.

Benefits of the Google Font API include:

A choice of high quality open source fonts.

Works in most browsers.

Extremely easy to use.

For example, the following text uses a web font called Tangerine:

Making the Web Beautiful!

Applying a font is easy: just add a special stylesheet link to your web page, then use the font in a CSS style.

For details, see the quick start example.

To give developers a choice of high-quality fonts when using the Font API, we have created the Google Font Directory. There you can browse our catalog of available fonts, learn about the font designers who created them, and copy the code required to use them on your web page.

The fonts in the directory are all released under open source licenses; you can use them on any non-commercial or commercial project.

Visit the Google Font Directory now

refer: http://code.google.com/intl/tr-TR/apis/webfonts/

MVC virtualPathProvider

2010-06-10T14:09:00.001+03:00


        private string GetViewPath(string[] locations, string viewName,string controllerName)
        {

            for (int i = 0; i < locations.Length; i++)
            {
                path = string.Format(System.Globalization.CultureInfo.InvariantCulture, locations[i],
                                     new object[] { viewName, controllerName });
                if (this.VirtualPathProvider.FileExists(path))
                {
                    return path;
                }
            }
            return null;
        }
        
        
        private string GetViewPath(string[] locations, string viewName,string controllerName)
        {
            return pPaths.Where(pp => pp.Name == controllerName && pp.ciewName= viewName ).First().Path();
        }