yep better monitoring for performance, and better monitoring for sub optimal best practices;

an in your face gui and chart for things that are slow gives you motivation to...

just a guess, but cound the query might be truncating at exactly 2000 characters? it looks pretty darn close, maybe there's an odbc limitation somewhere?

can you switch to calling a...

i just had somethign similar, where the column value was the result of a convert(varchar,columnname) function.

I had to right click on the data source and select "Show Advanced Editor.

Then the...

this data is preventing the delete: there's child records in PharmInvOutItemPackageReceipts, that either need to be deleted first or ignored,and delete everything else based on the cutoff date.

SELECT...

based on the name, you are querying a view (_VW)

so it doesn't matter what columns are included in your query, it's the underlying tables that are assembled in the view...

if you call top 250, do you get 250 records?

if you call top 100 or top 101, and you get exactly that many records, then there are more records...

one of the first things you need to do when you upgrade from a lower version to a higher version, is to update statistics.

the engine uses stats differently, and...

https://msdn.microsoft.com/en-us/library/ms174383.aspx

Note

If string_expression is not of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes. To return values greater than 8,000 bytes, string_expression must be explicitly cast to...

Gail alluded to the issue TOP 100 without an order by, or an insufficient order by that covers your desired results.

add more columns to your order by, and change the...

you can create a SQL job or a stored procedure with Execute As Owner.

the SQL job or procedure would contain the restore command in it,and you grant the...

you'll probably need to investigate a bit more ; could their reasons for it be simply institutional inertial(we always needed db_owner just in case)

if an application is using this login,...

coolchaitu (8/24/2015)

---

Dear Jonas

We want our app login(prduser) to have ONLY execute permission to procedures.It must NOT be able to ALTER or DROP stored procedure. It is allowed to do everything...

There is a neat technique where you sum a case with a counter to get this kind of information.

SELECT SUM(CASE WHEN placement = 'L' THEN 1 ELSE 0 END)...

mufadalhaiderster (8/21/2015)

---

I am looking at my personal machine, so the path below it is pointing to be has to be the server.

C:\Program Files (x86)\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf

I know this might sound...

for me, its keyboard shortcuts that point to procedures i marked as system procedures, that dig into the current database context of various system views;

they help me find objects, script...