Viewing 15 posts - 9,016 through 9,030 (of 9,725 total)
I've actually already started adding semi-colons because there are times where it seems to help my code perform better (I guess because SQL doesn't have to decide if one of...
January 29, 2008 at 8:10 am
Wow. These are all very interesting suggestions. I'm glad I posted this topic. @=)
I've had difficulty figuring out how to use CTEs with my normal code needs and...
January 29, 2008 at 7:44 am
Not having used sql_variant before...
I was under the impression that sql_variant stores different datatypes in the same column. That you can determine which datatype to use for a specific...
January 29, 2008 at 7:42 am
There are ways around case insensitivity, but they aren't easy. There are usually cursors involved with Substrings or PatIndex/CharIndex used in the code.
We were forced to do a case...
January 29, 2008 at 7:16 am
Oh, yes. I have the same issue. I have developers who learned T-SQL from SS 6.5 or 7.0 and still refuse to update a lot of their practices,...
January 29, 2008 at 6:40 am
The point of my test was because someone at Microsoft (according to the OP) said that what many people have assumed for years about true about the pitfalls of Select...
January 29, 2008 at 6:28 am
You need to learn DOS commands. XCopy is probably your best bet.
Also, you'll need to make sure that:
A) Xp_Cmdshell is enabled on your SQL Server (check the SQL...
January 29, 2008 at 4:57 am
The quickest way (and as previously mentioned, you'll want to test this) is to script out all the objects in your database as Drop & Creates. Now you could...
January 29, 2008 at 4:50 am
Good point, Tim. I just found out about that yesterday. I'm about to spend a lot of time on Channel9. @=)
January 29, 2008 at 4:11 am
Like Matt, I would not do a Select Count(*). If you're only looking for the existence of the records instead of caring about how many records there actually are,...
January 29, 2008 at 4:10 am
Just a note, I don't think SSRS cares about the email address when it creates a snapshot. A bad email wouldn't cause it to not create the snapshot. ...
January 29, 2008 at 4:05 am
Post the full text of the error message please.
January 28, 2008 at 11:07 am
That's pretty cool. You should do the "Submit a Script" so that one gets into the newsletter. You'll get all sorts of feedback then. @=)
January 28, 2008 at 11:05 am
You're misreading what they are saying. They are not saying "create a file for each CPU" only. They are saying to do it based on your disk configuration...
January 28, 2008 at 11:02 am
You can't link indexes between tables. An index only ever goes on 1 table only.
The only way to link tables is with a foreign key constraint and that's not...
January 28, 2008 at 10:58 am
Viewing 15 posts - 9,016 through 9,030 (of 9,725 total)