2018-03-19 (first published: 2018-03-15)
392 reads
Generator
DynamicDateRangeGenerator
Generates # of dates in before/after current year.
No more hardcoded date ranges.
2016-08-08 (first published: 2016-07-28)
588 reads
2015-01-20
8,720 reads
2012-06-20 (first published: 2012-05-30)
6,579 reads
RE: Numbers stored as text - Excel to SQL- DTS
Hi AJ,Yes, all the sitename are populated.. I actually figured out the problem.. but not sure how would i be able to overcome this one..here is what is happenning..as per http://support.microsoft.com/kb/236605/EN-US/the first 8 rows in Excel determine the data type for rest of the rows in the sheet. IN my case first few rows have […]
2005-05-04
RE: Front end
We have been using an access front end and SQL server backend for several years. The program evolved from an Access front and backend application. The performance across a WAN is terrible. We moved to Citrix to keep the thing moving. We are migrating to a .net frontend. In the mean time you can use […]
2005-05-04
RE: URGENT... Help needed with xp_cmdShell
Thanks.Changing option in EM/Mgmnt/server Agent/JobSystem worked ok!
2005-03-23
NewID() in Order By
I have seen examples where NewId() is used in the order by. For example: Select TOP 10 * From Authors ORDER BY NEWID()What does NewID() in the order by clause is responsible for? Thanks in Advance.
2004-11-03
9 reads
RE: Moving SQL Logfiles
Alzdba,Thank you very much for your help. I was successful in completing the procedure as per your recommendation. Thanks again.
2004-06-10
RE: SQL Server Mag Contact ID
Amazing what a little public scrutiny will do. K. Brian Kelley, GSEC http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/
2003-12-12
1 reads
Blogs
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Set a Runtime Variable in an Azure DevOps Pipeline
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
A New Word: Symptomania
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers