Viewing 15 posts - 1,906 through 1,920 (of 3,232 total)
Look up xp_cmdshell in BOL. Be cautious how you implement this as it has security issues.
February 15, 2008 at 1:43 pm
Well, their perception is that it is the same. They could be doing a great job at parameterization and getting the SQL optimizer to reuse the query plans similar...
February 15, 2008 at 10:33 am
You'll get better help if you post your table DDL along with some sample data and your desired results.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
February 15, 2008 at 10:24 am
Make sure you are NOT running profiler on your database server. Run it on a workstation that has SQL Server client tools installed on it. Have you configured...
February 15, 2008 at 10:21 am
Thanks for the details Steve. I will not have time to go through your linked material until next week, but I will read it and then re-read your bullet...
February 15, 2008 at 9:26 am
I cringe at using EM for backup/restore operations. I always use T-SQL. I have found that many posters have a very low comfort level with using T-SQL for...
February 14, 2008 at 12:56 pm
Steve,
That is why David wrote the article; so we can have a professional debate on the topic. I for one don't know much about it but I'm being...
February 14, 2008 at 12:50 pm
Great read David. Your article offers me some comfort for a huge project that I have just been allocated to. Your garage building analogy hits the nail on...
February 14, 2008 at 9:03 am
I think it is used as a general term Jeff. In my previous job, I was an application developer for about 6 years. I showed some savvy with...
February 14, 2008 at 8:34 am
Ah. So you are only going to use this in a SELECT to diplay the values. I had thought that you were going to create a new column...
February 13, 2008 at 1:30 pm
What are you trying to accomplish? Storing dates in any other form than a datetime column causes problems down the road.
February 13, 2008 at 12:52 pm
Since the data is already in the table, it seems a bit much to store it another time but in a different format. How about using a view or...
February 12, 2008 at 4:05 pm
Also, bracket your database name in the RESTORE DATABASE statement. SQL Server does not like your database name. Use [015] instead.
February 12, 2008 at 3:54 pm
Darren,
SQL Server reads the original file locations from the header in the backup file and it attempts to restore the database to it's original location. What SQL Server...
February 11, 2008 at 4:12 pm
Look up 'backing up databases' in books online. You can either run the BACKUP DATABASE statement, or use the Management Studios GUI by right-clicking on the DB and going...
February 11, 2008 at 9:55 am
Viewing 15 posts - 1,906 through 1,920 (of 3,232 total)