Viewing 15 posts - 6,391 through 6,405 (of 9,725 total)
And don't forget the possibility out-of-date statistics. While most people only think about them when it comes time to read, my opinion is that bad stats can also affect inserts...
February 24, 2011 at 12:33 pm
As Ninja said, it's a guesstimate, not a science. But you can average out your monthly growth as a baseline, then talk to the business about upcoming trends. If the...
February 24, 2011 at 12:31 pm
Latin collation will not allow Polish characters. It sounds like you need to change the database collation. Look up "collations [SQL Server], about collations" in Books Online. (without the quotes)....
February 24, 2011 at 12:27 pm
Aaaaahhhhh. Good catch.
For some reason, I had it in my head that all I had to do was leave it at "Report and Continue" and that would cause it...
February 24, 2011 at 12:23 pm
I'm only assuming. I could never get the cube to process so long as "Key Not Found" was left as "Report and Continue." But as soon as I changed that...
February 24, 2011 at 11:55 am
Koen Verbeeck (2/24/2011)
SSIS doesn't have a date datatype, so in my opinion the best option is to do the conversion immediately in the source query.
The name is deceptive (database timestamp)...
February 24, 2011 at 11:50 am
adam spencer (2/24/2011)
in source table I am using an SQL command (query text) I have:
[FILE_RUN_DATE] [varchar](8) NULL,
in destination It is mappied to this column:
[FileRunDate] [datetime] NULL,
a. can...
February 24, 2011 at 11:48 am
The two methods I know of are to either use a webservice to get into SAP's database and call the data that way, or get SAP to provide a csv...
February 24, 2011 at 11:40 am
Stefan Krzywicki (2/24/2011)
SQLkiwi (2/24/2011)
David Benoit (2/24/2011)
I remember when I took my first programming class, Pascal (Turbo actually)...I did a term using Turbo Pascal at University too.
I remember taking Pascal in...
February 24, 2011 at 8:40 am
Grant Fritchey (2/24/2011)
Ian Scarlett (2/24/2011)
If I was in the market for one of those, I wouldn't buy from a company that does...
February 24, 2011 at 8:38 am
Koen Verbeeck (2/24/2011)
David Benoit (2/24/2011)
Ah the boldness of it all. I remember when I took my first programming class, Pascal (Turbo actually) (showing my age)
That doesn't necessarily make you old....
February 24, 2011 at 7:45 am
Tom.Thomson (2/23/2011)
I don't see much point in attempting obfuscation if the enemy can see inside the database.
That's a good point, Tom. But is "enemy" a good word choice here? Do...
February 24, 2011 at 4:16 am
Sorry to keep making calls for my blog, but this one is about Women in Technology. I'd really like y'all to take a look at it and comment away, if...
February 23, 2011 at 3:14 pm
SKYBVI (2/23/2011)
Thats wrong ,...Thats wa mistake , generally people do in an interview....
I don't think the answer actually has to be correct. This question sounds more like one designed to...
February 23, 2011 at 11:07 am
tosscrosby (2/23/2011)
Slur
Cur!
I tried to resist. Honest. But I couldn't. @=)
February 23, 2011 at 9:00 am
Viewing 15 posts - 6,391 through 6,405 (of 9,725 total)