Viewing 15 posts - 6,451 through 6,465 (of 49,571 total)
Patching a server is always a good idea, but unless you've run into a bug that's causing the high CPU usage and is fixed in that service pack, it's not...
March 11, 2015 at 7:43 am
In that case you don't need a function, look up FOR XML PATH and read up on how to use it for string concatenation.
March 11, 2015 at 6:49 am
Add one of the things that Lowell mentioned and monitor for a complete business cycle, be sure to include month and and year end in the time that you monitor...
March 11, 2015 at 6:48 am
You're using Oracle. Very different. Basically any query I write for you will not run on Oracle.
And of course the instructions telling you how to get the script out of...
March 11, 2015 at 6:33 am
Short answer: You don't.
Custom auditing if you want accurate, persisted data. Or, you can look at sys.dm_db_index_usage_stats, however that only retains information until SQL Server or the database is restarted.
March 11, 2015 at 6:04 am
river1 (3/11/2015)
Is it still in the sys.objects table after been droped?
No.
If the procedure was dropped some time ago, it's unlikely that the entry is still in the default trace. It...
March 11, 2015 at 6:02 am
Sure. Go read up on sp_create_trace and create one that suits your requirement.
The retention of the default trace isn't measured in time. It's in file size. 5 file of 20...
March 11, 2015 at 6:00 am
Modified date tracks schema changes. Not data changes.
March 11, 2015 at 5:58 am
Right click table -> script as > Create
Basically, we need you to post setup code so that I can just copy it, paste into Management Studio, hit run and have...
March 11, 2015 at 5:53 am
The default trace is 5 files of 20MB each, that's the same on every SQL server.
How far back that goes depends on how active the server is and how...
March 11, 2015 at 5:43 am
GilaMonster (3/11/2015)
Table definitions (as a CREATE TABLE statement)
Also, we need more than one row of sample data please. Enough to test any query written.
March 11, 2015 at 5:29 am
Filters on a select to limit down rows until you have the smallest subset that does throw the error. Then look at the computed column definition and see what it...
March 11, 2015 at 5:02 am
Even in full recovery, you wouldn't have been able to use that to find something that happened 'some time ago'. The log contains records back to the last log backup/checkpoint.
You...
March 11, 2015 at 5:00 am
Unless you have some auditing already set up, you probably can't.
This may indeed be a good time to revisit the security setup on that DB.
March 11, 2015 at 3:55 am
Firstly, go buy yourself a copy of T-SQL Fundamentals and read it. Excellent book for someone starting in databases.
Second, to help you we need some more information:
Table definitions (as a...
March 11, 2015 at 3:52 am
Viewing 15 posts - 6,451 through 6,465 (of 49,571 total)