well it depends on how users connect.

if everyone comes in from an application, and the application uses the same account for all users to connect, you have to get the...

are you using any monitoring software? spotlight, etc?

there's a good chance that some monitoring software is creating a trace to gather stats every five minutes and then killing it's own...

REVOKE would remove a GRANT that was already created;

you can get that list from sys.database_permissions, and script the DENY's from there.

but what about users who were simpyl added to...

if you

select * from MillionBillionRowTable

That takes a lot of time.

period.

you are returning a ton of data, and that requires resources.

the only way to speed that up is with...

Meatloaf (11/26/2014)

---

Hi Lowell,

Thank you for your reply. The data each have their own columns.

My current query is: SELECT EID, LName, FName, Phone FROM EmployeeContacts ORDER BY LName

How would...

it depends on the data.

if you are smart, and are storing them as three distinct strings in three columns, then yes of course. you simp-ly select three columns.

if you are...

best i can do ?

translate.google.com

---

Hello everyone!

I wanted to let you know of a problem I had after migration!

I had a select that in the previous version worked perfectly!

After the change,...

i believe if you call the same procedure with different ansi settings(ansi_null, etc), you get a different plan cache for each combination, which is created as they are called the...

this looks wrong.

it should be either localhost\instance or machinename\instance

so i'd expect some of these to be right:

-S localhost\SQLEXPRESS

-S .\SQLEXPRESS

-S PSIMONDS\SQLEXPRESS (asuming your machine is named PSIMONDS!)

-S 127.0.0.1\SQLEXPRESS

i've seen this before, i think this is part of sp_send_dbmail when you use the @attach_query_result_as_file = 1 option alongside @query_result_header = 1.

as i remember it, you have to NOT...

you also need to be aware of the number of fields in your splits...

if osmeone doesn't have a two part address, before the city, your fields could not line up...

when i query my dev server for tempdb, for example, i get three locations:

select * from tempdb.sys.database_files

well, i know three of them are stored in the registry, o a per-isntance basis.

EXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'BackupDirectory';

EXECUTE [master].dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer',...

yep your error goes directly to y assumptions: based on the sample data, the desired string always exists at the beginning.

Koen's suggestion is easily the fastest, but there's probably other...

by making the assumptions outlined below, you can use patindex to find the beginning of the first non-character letter, and grab the substring.

the desired string always starts the string.

some character...