Microsoft Sql Server Tutorials

SO HERE ARE MY QUESTIONS : 1. Am I allowed to ru...

2012-02-13T17:31:20.942-08:00

SO HERE ARE MY QUESTIONS :

1. Am I allowed to run my program using user "TestUser" since SQL is installed using "Glen" windows user?

2. Do I need to add access rights to "TestUser" to allow the user to have CREATE rights? (Note : for security reason, I can add other access rights except Administrator)

Hi, I appreciate you for this great blog. It w...

2012-02-13T03:20:52.281-08:00

Hi,
I appreciate you for this great blog. It was very helpful to me and to the one who read this page. You truly are a expert Programmer!

Quite informative post .I was knowing about Raid ....

2012-02-13T03:16:04.974-08:00

Quite informative post .I was knowing about Raid .Had read in engineering stream but was not knowing do much . This is the right blog for anyone who wants to find out about this topic. Great stuff, just great!

Clear comparision, thx!

2012-02-11T10:23:36.592-08:00

Clear comparision, thx!

Type 36 = GUID

2012-02-07T12:49:03.131-08:00

Type 36 = GUID

I did not understand your article.Could you provid...

2012-01-30T00:35:32.921-08:00

I did not understand your article.Could you provide this in detail.

I've blogged about this few days back here : ...

2012-01-26T20:36:19.075-08:00

I've blogged about this few days back here :

http://nilthakkar.blogspot.com/2012/01/specify-size-for-character-data-type.html

Nice post Aaron. They should make the length manda...

2012-01-25T16:01:50.457-08:00

Nice post Aaron. They should make the length mandatory for varchar and similar dt's. Not sure what was the thought process of not doing it in the first place.

This seems to work for me: Create Function dbo.GM...

2012-01-25T11:16:37.084-08:00

This seems to work for me:

Create Function dbo.GMT2Current(@Date DateTime) RETURNS Datetime
AS BEGIN
return DateAdd(minute, DateDiff(minute,GetUTCDate(),GetDate()), @Date)
END

I blogged about this here: http://sqlblog.com/blo...

2012-01-25T10:00:58.408-08:00

I blogged about this here:

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/10/09/bad-habits-to-kick-declaring-varchar-without-length.aspx

Note the connect items as well:

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=244395

http://connect.microsoft.com/SQL/feedback/ViewFeedback.aspx?FeedbackID=267605

is it possible to install them through WPI

2012-01-12T10:06:27.997-08:00

is it possible to install them through WPI

Is it possible to select the Full Backup to use wh...

2012-01-05T08:04:39.408-08:00

Is it possible to select the Full Backup to use when you to a Differential Backup ?

2012-01-05T08:03:13.543-08:00

This comment has been removed by the author.

I have tried many tools but all works when SQL Ser...

2011-12-28T21:14:47.819-08:00

I have tried many tools but all works when SQL Server is installed. I have already used SQLIOStress but won't remember it required SQL Installation or not. Thanks for sharing SQLIOSim updated version.

I appreciate you for sharing this new tip. But I w...

2011-12-28T21:05:46.718-08:00

I appreciate you for sharing this new tip. But I was using SQL Recovery Software to repair MDF File because I did not have updated backup. Now I will use DBCC & CHECKDB command to check & fix MDF corruption.

After many hours searching and trying 'solutio...

2011-12-25T13:26:19.168-08:00

After many hours searching and trying 'solutions', I finally managed to find something that actually works and I can easily understand.

Thanks! :)

This is one of the best answer so far, I have rea...

2011-12-24T06:56:21.714-08:00

This is one of the best answer so far, I have read online.Just useful information. Very well presented. I had found another good collection of index in sql server over internet.
please check out this link...
Index in sql server

Thanks

USE [AdventureWorks] GO SET ANSI_NULLS ON GO...

2011-12-23T05:37:13.909-08:00

USE [AdventureWorks]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[Demo_MultipleResultSets]

AS

BEGIN

SET NOCOUNT ON;

SELECT TOP 2 * from Production.Product;

SELECT TOP 2 * from Sales.Customer;

SET NOCOUNT OFF;

END

What if the string does not contains only digits? ...

2011-12-16T15:20:28.844-08:00

What if the string does not contains only digits? Can this computer science breakthrough be applied to "1" removal with some little modifications?

SERIOUSLY !!

2011-12-15T14:15:55.380-08:00

SERIOUSLY !!

Super work, can you also specify how to put "...

2011-12-13T20:47:54.032-08:00

Super work, can you also specify how to put "/" in place of "-"

Thank you for sharing the wonderful information.I ...

2011-12-12T01:02:18.314-08:00

Thank you for sharing the wonderful information.I look forward your blog to know more lke this.

Would there be an easy way to add the database nam...

2011-12-09T07:52:34.442-08:00

Would there be an easy way to add the database name to the result set? It is not a part of either table used in the query you provided so it would have to come from somewhere else. Thanks!

This makes me want to cry. it still isn't work...

2011-11-28T16:47:22.224-08:00

This makes me want to cry. it still isn't working

Great post! Just what I needed, thanks!

2011-11-24T07:36:12.563-08:00

Great post! Just what I needed, thanks!