2005-03-02
Azure SQL Data Warehouse (ASDW)
RE: Getting stuck and feeling useless! please help!
Tim,This is a divide and conquer case. As a guidance you can take a look at the following code Create table #TDups( Person_Id int, Role varchar(50), Dte datetime, Surname varchar(50), Forename varchar(50), Dob datetime)Insert into #TDups( Person_Id, Role , Dte, Surname, Forename, Dob) Select P.Person_ID, P.Role, P.Dte, P.Surname, P.Forename, P.Dob From […]
2005-02-25
RE: EM of SQL 2000 hang
I am not administering 2005 database. All the database are of 2000 , I just installed 2005 beta version
2005-02-13
Aye Yi Yi
AOL reports 90% of it's incoming SPAM comes from other ISP's mail relays. The estimate is that at this pace of growth, we'd be looking at 95% of all email being SPAM by mid-2006. I think 95% of my email right now is SPAM, so if things stayed the same, I'd be ok with that. […]
2005-02-07
9 reads
2005-02-07
RE: DB Limitations in sql server
Heck, I'll throw out the "O" word here. You might even want to look at Oracle 10G grid computing. It may be a better solution depending on what you are doing. We're just coming off our last Oracle database. A little harder to setup initially, but once it came up we ran for almost 3 […]
2005-02-02
RE: backup question
In a heavy load, having two log files, perhaps on two disks, can help performance.
2005-01-28
2005-01-28
RE: Date Column with NULL value
It's a bit difficult to believe that you would ever have a NULL StartDate with a valid EndDate. Normally, it's the other way around. But, no worries...For NULL StartDates, I would treat them as if they were '01/01/1900' and I would treat NULL EndDates as if they were '12/31'9999'SELECT * FROM xyz WHERE ISNULL(StartDate,'01/01/1900') < […]
2005-01-27
user not able to run jobs
I have a developer who I want to be able to create and run jobs on a test server. He has db_owner on his own database, and even db_owner on msdb. He can view and edit the jobs, but he isn't able to run them. He is not the owner of the job; I have a […]
2005-01-19
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
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