all NCI access that needs extra data will use the clustered index to fetch that data.

what columns do you expect to get used ?

Provide indexes for those columns and try...

The good thing is: your test also fails here ( sql2012 SP1 CU7 (Build number: 11.0.3393.0))

I've also tested it with a couple of other 850-collations. All fail !

These are...

First question to pose is: Shoud that column have nulls ?

Second question to pose is: wouldn't a default empty varchar do the same trick ? If so modify the data...

avdhut.k (12/3/2013)

My requirement is,

I want to capture exact date and time,

I am trying using,

Select Convert(varchar(10),GetDate(),112)

output :- 20131203

Above statement gives...

only if the existance of a value in the parent table is mandatory for your data model.

Do they have the same level of detail ?

apparently the regex should be like this:

DECLARE @Table1 TABLE

(

Column1 VARCHAR(32) NOT NULL PRIMARY KEY

);

INSERT @Table1(Column1)

VALUES

('abcdef123'),

('abcdef[123'),

('abcdef]123'),

('abcdef].123'),

...

xp_fixeddrives shows free space on the drives the sqlinstance can see.

As you now experience, being granted windows level authorities is still a privilege.

Even though an experienced sqlserver dba will need...

can you post the errors SQLAgent.OUT has about this job / powershell ?

did you try to double up the bracket you're looking for?

'%[]]%'

We use scheduled sqlagent jobs to create the wanted types of backups at the desired time intervals.

So we use TSQL steps to actually create the backups.

We also use backup devices,...

FWIW I still follow the same guidelines as I used a couple of years ago when designing SQLServer hardware.

In dev we don't have the luxury of SSD or Tiered SAN.

In...

Books online has a nice topic on datetime http://technet.microsoft.com/en-us/library/ms187819(v=sql.105).aspx

According to this overview state 1 means your login (i.e. sa) is disabled.

Troubleshooting Error 18456

http://sqlblog.com/blogs/aaron_bertrand/archive/2011/01/14/sql-server-v-next-denali-additional-states-for-error-18456.aspx

you can download ( free ) the Microsoft JDBC Driver 4.0 for SQL Server drivers at http://www.microsoft.com/en-us/download/details.aspx?id=11774

oh, yes, indeed, totally forgot about DNS aliasses, however this being a client level issue, chances are it is a client side defined SQLServer alias.

SQL Server Configuration Manager / SQL...