Viewing 15 posts - 9,076 through 9,090 (of 9,713 total)
Interesting note. In the Microsoft Self Paced Training kit for 70-441, the book says
However, you cannot optimize all types of queries. For example, a query such as...
January 24, 2008 at 5:14 am
Enterprise 32 bit (for the servers) and Developer 32 bit (for our local PCs).
January 24, 2008 at 4:38 am
If the arabic script has no Roman/English characters in it, you should be able to use the following WHERE clause.
WHERE MyColumn not like '[a-z]%'
And if your collation is set up...
January 24, 2008 at 4:34 am
Verify via the SQL Server Surface Area Configuration Tool that you have xp_cmdshell enabled on this server. Usually when something takes that long before returning an error, it's stuck...
January 24, 2008 at 4:28 am
You can't downgrade a DB to SQL 2000, but you can script out all the objects, recreate them in SQL 2000, move some of the data (top 1000 or 5000...
January 24, 2008 at 4:24 am
I can't give you actual monitoring scripts because I didn't write some of them and I don't have permissions to hand the ones I didn't create. Also, you can...
January 24, 2008 at 4:22 am
BOL also has some good tutorials. And if you don't have access to SQL Server at the moment, you can either download the eval version of 2k5 or (recommended)...
January 24, 2008 at 3:59 am
And save all your T-SQL scripts! You'd be amazed at how handy that comes in 6 months down the road when you need to replicate that "one time" job.
January 23, 2008 at 11:25 am
Dennis,
The best way to see what SQL process are using up the memory is go into System Monitor and choose the regular OS memory counters as well as whatever SQL...
January 23, 2008 at 7:58 am
I've done it where I've had multiple data sources in the report, then just edited the DataSets right after Testing so that it pointed to the proper data source when...
January 23, 2008 at 5:44 am
SQL 2k5 has a whole bunch of new system catalog views that help you identify unused indexes, etc. Check out "sys.dm_db_index" in BOL. This will get you to the...
January 23, 2008 at 5:40 am
I started reading the Self Paced training kit for 70-441 (one of the Dev exams) and found that it discusses some of the BI stuff at an "introductory" level. ...
January 23, 2008 at 5:28 am
Ideally the powerful userids are saved in a sealed envelope...in your bosses desk.
Ummm, forgive me for disagreeing with that statement, but I've seen too many stuff stolen by other coworkers...
January 22, 2008 at 5:51 am
I'm glad you finally got it working.
Mis-Aligned Height settings can also mess you up. So if you haven't checked that already, you should.
January 22, 2008 at 4:09 am
Viewing 15 posts - 9,076 through 9,090 (of 9,713 total)