something like this seems pretty close for a fast query:

SELECT

DB_NAME(database_id) AS TheDatabase,

OBJECT_NAME(object_id,database_id) As TheTableName,

SUM(user_seeks) AS user_seeks,

SUM(user_scans) AS user_scans,

SUM(user_lookups) AS user_lookups,

...

Steve Jones - SSC Editor (2/27/2013)

---

Haven't seen a lot on it. I know Adam Machanic and a few people use it, but don't see much written.

I did run across this:...

or did you mean the last non-null column, regardless of the datetime value? my example above finds the highest date, regardless of which column.

in that case, assuming your app files...

great job on giving us the setup DDL and Data.

Your data has all the same datetimes, so it'll probably look better when you compare the example with real data.

this seems...

wow save that 35K for bonuses!

my first link for creating a free VPN between networks:

http://www.wikihow.com/Set-Up-a-Virtual-Private-Network-with-Windows

another possibility might include secure FTP to throw files on endpoints accessible to both servers.

dlangschied (2/27/2013)

---

I needed to export some data from SQL 2000 database to Excel. I only needed a portion of two of the tables, so I generated as a Visual...

great jo providing the setup data!

Here's another fast way using the PARSENAME function;

PARSENAME is usually used to split object names, like ServerName.Databasename.dbo.TableName,

but can be used for IP address and...

YSL i put this together in a different post, it scripts out all your database mail settings;

for me this is handy when i want to winmerge and look for subtle...

MDX is nothing i've played with, but my google fu pointed me here:

http://www.google.com/search?q=mdx+bitwise+operations

and that seems to say you've got to add some .net toys? because MDX does not do bitwise...

but two years would be 730 days (365 x 2?), not 2, right?

DELETE FROM incident WHERE DATEDIFF(DD, CAST(getdate AS DATE), created) > 730

another thing to consider is to search any sourcecode for object names;

we have plenty of "functionality" that exists in various application, but noone ever uses the functions in real life;

As...

monilps (2/26/2013)

---

Hey,

Thank you for quick response

What I meant was

For Ex:

Row1: aaaaaaa 02/20/2002 jjjjjj sddsdjjjjsdsd sdsds

Row2: asdlajsd fjsdfjkdgn dsjbfks, dfjksflml,fsf,f sdfsdf 9/3/99 sjdfnsdnf sjdfoisofn

Row3: sdkfjos fjsdopfj uyro dlsfl 02-02-02...

it'll take a bit of work, and you'll need the DelimitedSplit8K function (search SSC and read the article)

things like 02/02 and 02-02 are not dates, so they do not get...

possible, but i wouldn't recommend it; deletes should be decided based on some analysis, and not just because a table might contain a columname that matches or something. Additionally, you...

if you use SET XACT_ABORT ON, you can make the code a little easier to read; if any error occurs, it stops the process and rollsback the transaction automatically:

each delete...