Viewing 15 posts - 1,021 through 1,035 (of 3,061 total)
Rich Yarger (6/13/2011)
I typically don't either, but when your awesome employer is paying for you to take it - it's kinda hard to hide!
Been there. Take the test on Saturday...
June 14, 2011 at 2:32 pm
Rich Yarger (6/10/2011)
June 13, 2011 at 7:12 am
kollisudheer27 (6/13/2011)
"Cannot drop the procedure 'xp_regdeletekey', because it does not exist or you do not have permission."
how can i resolve...
June 13, 2011 at 5:30 am
Raghavender (6/11/2011)
June 12, 2011 at 6:39 am
sqlfriends (6/11/2011)
How can I monitor the backup file size increase?
Look at Backup/Restore History Tables in msdb database.
On SS2K8R2 backupfile history table willl do the trick http://msdn.microsoft.com/en-us/library/ms188653.aspx
June 12, 2011 at 6:03 am
Tobias Ortmann (6/8/2011)
Yes, the columns are defined in bytes.
We changed them to charaters and it works.
But I don't understand why 🙂
We read from varchar2(50 bytes) and insert into...
June 12, 2011 at 5:55 am
sqlfriends (6/11/2011)
You said there are serveral ways, so beside sp_helpfile, what else can I use?
if you are after ballpark numbers and interested in past history too the easiest way is...
June 11, 2011 at 2:59 pm
Jeff Moden (6/9/2011)
PaulB-TheOneAndOnly (6/9/2011)
June 9, 2011 at 8:00 am
Jeff Moden (6/9/2011)
PaulB-TheOneAndOnly (6/8/2011)
General structure should looks like:
SELECT
list-of-colums-to-be-returned
FROM
list-of-tables
WHERE
...
June 9, 2011 at 4:55 am
Arthur Gary (6/8/2011)
i.e. changes in subscription, how do I track the changes in the money values without doubling the count in subscriptions?
mmhh... you may have it backwards. Facts do not...
June 8, 2011 at 3:46 pm
Tobias Ortmann (6/7/2011)
ORA-12899: value too large for column "TEST"."TABLENAME"."TEXTCOLUMN" (actual: 52, maximum: 50)
Have Oracle side columns defined their sizes in bytes? like varchar2(50 bytes)?
Double the size of the columns or...
June 8, 2011 at 3:32 pm
Filtering should be done in WHERE clause and not in SELECT.
General structure should looks like:
SELECT
list-of-colums-to-be-returned
FROM
list-of-tables
WHERE
conditions-for-filtering-and-access
;
June 8, 2011 at 3:26 pm
I would move the other tables.
Why move a table that takes 90% of the space while you can move the ones that take 10% ?
If the answer is "because...
June 7, 2011 at 4:46 pm
kwoznica (6/7/2011)
Or does the application code need to specify transactional...
June 7, 2011 at 4:39 pm
alnawrass2002 (6/4/2011)
after changing my SQL sa password all my maintenance plans & my jobs failed to excute?
This is one of the reasons why schedulled jobs shouldn't login into the system...
June 4, 2011 at 11:30 am
Viewing 15 posts - 1,021 through 1,035 (of 3,061 total)