Viewing 15 posts - 5,371 through 5,385 (of 9,722 total)
davemiller3 (8/11/2011)
Thanks for replying -Here's an update: if I remove the distinct from the statement, it runs (the cursor opens). Whatever that means !!!!
The DISTINCT keyword...
August 12, 2011 at 4:42 am
NJ-DBA (8/11/2011)
select a.country,a.zone,a.branch,a.user1 as 'user', b.user1 as user2from test a, test b
where a.user1='farooq'
and b.user1='jawwad'
Um, don't use this code. It's outdated, deprecated, and will disappear from SQL Server in the future...
August 11, 2011 at 1:23 pm
sqlmaverick (8/11/2011)
August 11, 2011 at 1:21 pm
davemiller3 (8/11/2011)
I have a cobol stored proc / assembly that runs the following code:
....
The SQL runs fine in both versions of SQL. It runs fine as an...
August 11, 2011 at 1:20 pm
Include Action Execution plan in SSMS (check under Query). Often time, execution times can be explained by the way the SQL Server db engine decides to do similar queries in...
August 11, 2011 at 1:18 pm
Grant Fritchey (8/11/2011)
Well done Brandie. The only real author I know and we still haven't met.
I think it's hilarious that you think you're not a real author.
You're writing, aren't you?
You're...
August 11, 2011 at 11:44 am
I'm published again! "Tales We'll Tell Tomorrow" is the final chapter in the Shadowrun Street Legends sourcebook. It's a novelette this time and my editor loved my fight scene.
If you're...
August 11, 2011 at 11:10 am
Thank you for the response. I appreciate it.
August 11, 2011 at 9:07 am
Additional filegroups also comes in handy for partial backups and segregating read/write information from read only information.
So don't assume that because everything is on the same logical drive that prevents...
August 11, 2011 at 8:43 am
You're very welcome. Let us know the results once you have them (good or bad) as that will help others who stumble across this thread in the future.
August 11, 2011 at 8:41 am
I have a separate job that executes on a 15 minute reoccurring schedule to look for files on a certain day within a certain time frame (say, 4 hours). If,...
August 11, 2011 at 7:20 am
This almost sounds like an interview question.
Are you a dev dba / BI person that just moved into a production dba position?
Maybe I misunderstood your question, but not all...
August 11, 2011 at 5:40 am
archanab (8/11/2011)
I have to design a data base for a sales distribution system. The system has to maintain large number of parts ,customers and orders information etc.....
Fortunately for you, Microsoft...
August 11, 2011 at 5:35 am
Is it just me, are am I being particularly unhelpful this morning?
http://www.sqlservercentral.com/Forums/Topic1158208-391-1.aspx
http://www.sqlservercentral.com/Forums/Topic1158308-391-1.aspx
August 11, 2011 at 5:19 am
Gail rarely needs to do prep. She's so immersed in the internals that she already knows most of what's going to be on the exam. It helps that she rescues...
August 11, 2011 at 5:15 am
Viewing 15 posts - 5,371 through 5,385 (of 9,722 total)